Hello everyone
I am on Stata 17 trying to do a challenging summary statistics table
I'm interested in creating two tables of mean, median, and standard deviations for a set of variables placed in the rows obtained for the values of the variables in the columns and their constraint conditions using their labels for all variables and variables in the columns, that can be imported into a latex document.
What I would like is to create classification of variables in the rows, such as classification A and from below their variables; classification B and from below their variables, etc., using their labels; and variables in the columns, averaging the variables for each classification.
To provide more clarity in the analysis, for the purpose of the table, I provide a layout how it should look created with excel. I work with a panel where I have id, year, country, and variables, and I only classify variables in the rows. I do not have a group variable in the dataset or other
index1 etc are continuous custom indicators and cat is a categorical variable of the measure of an event duration in years .
Therefore, for cat, for the second table I would like the same statistics with cat cat1 cat2 etc in the columns adding this time and extra statistics that is the difference of the means of each year, or better how means variate. In other workd mean2- mean1 etc
I have tried with
but that did not work.
I have also generated the >0 and <0 for indexs but then I got stack.
I am mentioning that I work with stata 17 because I cannot use the new
command available only in version 18.
Thank you so much in advance for any help. Perhaps people like Jeff Pitblado could be of help.
Giorgio
I am on Stata 17 trying to do a challenging summary statistics table
I'm interested in creating two tables of mean, median, and standard deviations for a set of variables placed in the rows obtained for the values of the variables in the columns and their constraint conditions using their labels for all variables and variables in the columns, that can be imported into a latex document.
What I would like is to create classification of variables in the rows, such as classification A and from below their variables; classification B and from below their variables, etc., using their labels; and variables in the columns, averaging the variables for each classification.
To provide more clarity in the analysis, for the purpose of the table, I provide a layout how it should look created with excel. I work with a panel where I have id, year, country, and variables, and I only classify variables in the rows. I do not have a group variable in the dataset or other
index1 etc are continuous custom indicators and cat is a categorical variable of the measure of an event duration in years .
Therefore, for cat, for the second table I would like the same statistics with cat cat1 cat2 etc in the columns adding this time and extra statistics that is the difference of the means of each year, or better how means variate. In other workd mean2- mean1 etc
I have tried with
Code:
tabstat
I have also generated the >0 and <0 for indexs but then I got stack.
Code:
generate index1_ge =. replace index1_ge= index1 if index1>0 generate index1_le =. replace index1_le =index1 if index1<0 generate index2_ge =. replace index2_ge= index2 if index2>0 generate index2_le =. replace index2_le =index2 if index2<0 generate index3_ge =. replace index3_ge= index3 if index3>0 generate index3_le =. replace index3_le =index3 if index3<0 generate index4_ge =. replace index4_ge= index4 if index4>0 generate index4_le =. replace index4_le= index4 if index4<0
I am mentioning that I work with stata 17 because I cannot use the new
Code:
dtable
Thank you so much in advance for any help. Perhaps people like Jeff Pitblado could be of help.
Giorgio
Code:
* Example generated by -dataex-. For more info, type help dataex clear input float(year id) str97 country str1 group float(fd ka ext dom pr la index1 index2 index3 index4) byte cat 1992 1 "Country1" "A" .524175 2.321955 .75 .7777778 .071428575 1 12.2 6.5 0 1 5 1993 1 "Country1" "A" .5846328 2.321955 .75 .7777778 .071428575 1 17.553352 0 0 1 2 1994 1 "Country1" "A" .6478685 2.321955 .75 .9444444 .071428575 .7912164 19.11 8.6 0 1 4 2000 1 "Country1" "A" .8414965 1.048859 .75 1 .53571427 .7782844 28.634 -9.788 0 1 3 2001 1 "Country1" "A" .873997 1.048859 .75 1 .6190476 .7782844 26.41307 6.464286 0 1 5 2002 1 "Country1" "A" .8985876 1.048859 .75 1 .6190476 .7661784 5.536341 0 0 1 2 2003 1 "Country1" "A" .9015374 1.048859 .75 1 .6190476 .7661784 5.536341 -14.278473 0 1 3 2004 1 "Country1" "A" .9041975 1.048859 .75 1 .6190476 .7661784 7.350179 2.7697804 0 1 4 2010 1 "Country1" "A" .941813 1.048859 .875 1 .8452381 .7704133 6.241802 5.2 0 1 5 2011 1 "Country1" "A" .934702 1.048859 .875 1 .8452381 .7704133 5.068 0 0 1 2 2012 1 "Country1" "A" .9079577 1.303478 .875 1 .8452381 .7704133 5.068 -21.986 0 1 3 2013 1 "Country1" "A" .8901507 1.5580974 .875 1 .8452381 .7694158 7.929047 -4.5 0 1 4 1992 2 "Country2" "A" .399736 .6099069 .875 .7777778 0 .5697657 1.6 0 0 1 2 1993 2 "Country2" "A" .461959 2.0673358 .875 .9444444 0 .5697657 6.996447 5.2 0 1 5 1994 2 "Country2" "A" .4953545 2.321955 .875 .9444444 0 .5697657 8.69136 -21.986 0 1 3 2000 2 "Country2" "A" .7018992 2.321955 1 1 .4404762 .5697657 2.364474 -4.5 0 1 4 2001 2 "Country2" "A" .7035186 2.321955 1 1 .5952381 .5697657 2.364474 0 1 0 2 2002 2 "Country2" "A" .6993845 2.321955 1 1 .5952381 .5457992 -.7668521 29.073414 .49041095 .509589 5 2003 2 "Country2" "A" .7077955 2.321955 1 1 .5952381 .5457992 -2.9592714 18.228453 0 1 4 2004 2 "Country2" "A" .728983 2.321955 1 1 .5952381 .5457992 -2.950783 -6.882123 0 1 3 2010 2 "Country2" "A" .7894757 2.321955 1 .9444444 .9166667 .5718316 3.891 31.695776 0 1 5 2011 2 "Country2" "A" .8007692 2.321955 1 .9444444 .9166667 .5718316 3.891 0 1 0 2 2012 2 "Country2" "A" .7593077 2.321955 1 .9444444 .9166667 .5718316 -2.5410414 22.593 0 1 4 2013 2 "Country2" "A" .7435991 2.321955 1 .9444444 .9166667 .5718316 -6.333579 -7.235 0 1 3 1992 3 "Country3" "B" .5840359 2.321955 1 .7777778 .08333334 .6281998 .3835026 29.936 0 1 3 1993 3 "Country3" "B" .6147648 2.321955 1 .8888889 .08333334 .6281998 .3835026 0 .21153846 .7884616 2 1994 3 "Country3" "B" .632942 2.321955 1 .8888889 .08333334 .6260909 .8169867 27.6381 0 1 4 2000 3 "Country3" "B" .7692201 2.321955 1 .8888889 .75 .6297867 1.9049623 -7.235 .33516484 .6648352 3 2001 3 "Country3" "B" .7502941 2.321955 1 .8888889 .75 .6297867 1.9049622 0 .4917582 .5082418 2 2002 3 "Country3" "B" .7244223 2.321955 1 .8888889 .8333333 .6297867 1.283737 14.872792 .3763736 .6236264 3 2003 3 "Country3" "B" .7401305 2.321955 1 .8888889 .8333333 .6297867 -1.3254085 48.458 0 1 4 2004 3 "Country3" "B" .7518873 2.321955 1 .8888889 .8333333 .6547069 -1.3254085 -8.191456 1 0 3 2010 3 "Country3" "B" .7356597 2.321955 1 .9444444 1 .6547069 1.1606808 0 1 0 2 2011 3 "Country3" "B" .7201834 2.321955 1 .9444444 1 .6547069 1.1606808 5.187 0 1 4 2012 3 "Country3" "B" .7283527 2.321955 1 .9444444 1 .6547069 1.1606808 31.889 0 1 4 2013 3 "Country3" "B" .7077386 2.321955 1 .9444444 1 .6547069 1.1165322 -29.707 1 0 3 1992 4 "Country4" "B" .3452282 .6099069 .875 .5555556 .071428575 .6121462 2.615249 5.187 0 1 4 1993 4 "Country4" "B" .3790323 2.0673358 1 .7222222 .071428575 .6121462 1.4437795 0 1 0 2 1994 4 "Country5" "C" .4175321 2.321955 1 .7222222 .071428575 .6121462 4.0116615 29.87246 0 1 4 2000 4 "Country5" "C" .759881 2.321955 1 .8888889 .7619048 .6121462 5.97681 -29.707 1 0 3 2001 4 "Country5" "C" .7410694 2.321955 1 .8888889 .7619048 .6121462 7.402936 0 1 0 2 2002 4 "Country5" "C" .7281089 2.321955 1 .8888889 .8333333 .6121462 8.534 . . . 4 2003 4 "Country5" "C" .735869 2.321955 1 .8888889 .8333333 .6263371 8.534 5.674 0 1 4 2004 4 "Country5" "C" .7334849 2.321955 1 .8888889 .8333333 .6263371 8.534 -21.978655 1 0 3 2010 4 "Country5" "C" .7798166 2.321955 1 .9444444 .9166667 .6263371 -16.25 0 1 0 3 2011 4 "Country5" "C" .7637033 2.321955 1 .9444444 .9166667 .6263371 -14.330358 . . . 4 2012 4 "Country5" "C" .7608096 2.321955 1 .9444444 .9166667 .6263371 0 5.674 0 1 4 2013 4 "Country5" "C" .7455279 2.321955 1 1 .9166667 .607849 .6806767 37.456 1 0 3 1992 5 "Country6" "C" .1757301 . . . . . . . . . 3 1993 5 "Country6" "C" .1761862 . . . . . . . . . 3 1994 5 "Country6" "C" .1562944 . . . . . . -6.130934 .2967033 .7032967 4 2000 5 "Country6" "C" .2008834 -1.2261546 . . . . . 37.456 1 0 3 2001 5 "Country6" "C" .17261477 -1.2261546 . . . . . . . . 3 2002 5 "Country6" "C" .21249928 -1.2261546 . . . . . . . . 3 2003 5 "Country6" "C" .2206576 -.02334493 . . . . . -34.113 1 0 4 2004 5 "Country6" "C" .23541167 -.02334493 . . . . . 35.647743 1 0 3 2010 5 "Country6" "C" .27683625 1.249751 . . . . . . . . 3 2011 5 "Country6" "C" .27487376 1.249751 . . . . . . . . 3 2012 5 "Country6" "C" .27767062 1.249751 . . . . . -34.113 1 0 4 2013 5 "Country6" "C" .2884341 1.249751 . . . . . -1.262 1 0 3 1992 6 "Country7" "C" .25534174 -.1539507 .625 .5 0 .8271327 . . . . 2 1993 6 "Country7" "C" .28078705 -.1539507 .625 .5 .16666667 .8271327 . . . . 3 1994 6 "Country7" "C" .3567602 -.1539507 .625 .5555556 .16666667 .8271327 . -17.802141 .7142857 .2857143 4 2000 6 "Country7" "C" .4190661 -1.2261546 .625 .6111111 .23809524 .8271327 . -1.262 1 0 3 2001 6 "Country7" "C" .3738855 -1.2261546 .625 .6666667 .3928571 .8271327 . . . . 2 2002 6 "Country7" "C" .404098 -1.2261546 .625 .6666667 .3928571 .8271327 . . . . 3 2003 6 "Country7" "C" .4157713 -1.2261546 .875 .6666667 .3928571 .7653575 . 22.975 0 1 4 2004 6 "Country7" "C" .4085605 -1.2261546 .875 .6666667 .53571427 .7653575 . -2.527769 1 0 3 2010 6 "Country7" "C" .4888775 -.02334493 .875 .6666667 .7619048 .7653575 . . . . . 2011 6 "Country7" "C" .4789392 -.02334493 .875 .6666667 .7619048 .7653575 . . . . . 2012 6 "Country7" "C" .4922497 -.02334493 .875 .6666667 .7619048 .7653575 . . . . . 2013 6 "Country7" "C" .508882 -.02334493 .75 .6666667 .7619048 .7653575 . . . . . 1992 7 "Country8" "D" .56565696 2.321955 1 .9444444 .7738096 .8009957 13.403038 . . . . 1993 7 "Country8" "D" .6403931 2.321955 1 .9444444 .7738096 .8070084 12.1 . . . . 1994 7 "Country8" "D" .6921942 2.321955 1 .9444444 .8452381 .8070084 12.1 . . . . 2000 7 "Country8" "D" .8552948 2.321955 1 1 .9285714 .8314556 1.806 . . . . 2001 7 "Country8" "D" .8805222 2.321955 1 1 .9285714 .8314556 1.958802 . . . . 2002 7 "Country8" "D" .8265579 2.321955 1 1 .9285714 .8314556 2.076 . . . . 2003 7 "Country8" "D" .8580942 2.321955 1 1 1 .8314556 2.076 . . . . 2004 7 "Country8" "D" .8708485 2.321955 1 1 1 .8314556 2.076 . . . . 2010 7 "Country8" "D" .8683383 2.321955 1 1 1 .8314556 3.564247 . . . . 2011 7 "Country8" "D" .8672714 2.321955 1 .9444444 1 .8314556 5.454876 . . . . 2012 7 "Country8" "D" .8684435 2.321955 1 .8888889 1 .8429364 5.454876 . . . . 2013 7 "Country8" "D" .8866873 2.321955 1 .9444444 1 .8429364 5.454876 . . . . 1992 8 "Country8" "D" .5748482 2.321955 1 .8888889 .52380955 .9702252 14.9 . . . . 1993 8 "Country8" "D" .6702072 2.321955 1 .8888889 .52380955 .9702252 .0375137 . . . . 1994 8 "Country8" "D" .6812267 2.321955 1 .8888889 .52380955 .9702252 -.781 . . . . 2000 8 "Country8" "D" .8790284 2.321955 1 1 .75 .9702252 1.463 . . . . 2001 8 "Country8" "D" .889005 2.321955 1 1 .75 .9702252 5.542341 . . . . 2002 8 "Country8" "D" .8849987 2.321955 1 1 .75 .9702252 5.767 . . . . 2003 8 "Country8" "D" .8916724 2.321955 1 1 .75 .9702252 5.767 . . . . 2004 8 "Country8" "D" .8910962 2.321955 1 1 .75 .9702252 5.767 . . . . 2010 8 "Country8" "D" .8951228 2.321955 1 1 .8333333 .9702252 -.36 . . . . 2011 8 "Country8" "D" .8785759 2.321955 1 1 .8333333 .9702252 -.36 . . . . 2012 8 "Country8" "D" .8894278 2.321955 1 1 .8333333 .9702252 -.36 . . . . 2013 8 "Country8" "D" .8901961 2.321955 1 1 .8333333 .9702252 1.298654 . . . . end
Attached Files
Comment