Dear All:
I use the -makematrix- command -followed by -mat2txt- to produce tables of descriptive statistics.
It works perfectly with the following command:
makematrix c1, from(r(N) r(mean) r(sd))label : univar var1 var2 var3 var4 if president==1
makematrix c2, from(r(N) r(mean) r(sd)) label : univar var1 var2 var3 var4 if president==0
makematrix c3, from(r(z) 2*normprob(-abs(r(z)))) label : ranksum var1 var2 var3 var4 , by(indep)
matrix c4 = c1 , c2, c3
matrix colnames c4 = N "Mean" "Standard deviation" N "Mean" "Standard deviation" "Mann-Whitney U-test (Z)" "Mann-Whitney U-test (p-value)"
mat2txt, matrix(c4) saving(stat_formation_metier) append
I only have a little question: I append several tables (I rerun the same command replacing "president" by other variables) and there is no way to distinguish the content of each table without remembering the origin of the computation.
I searched in the help for -makematrix- and did not find a possibility to give a title to each table (the c4 matrix in my example). It would be nice to have a title in the upper-left cell of the table, for example "President", in the same column as the variables names.
Do you think this could be possible?
Best regards
Herv� Stolowy
***********************************************************
Professeur/Professor
Coordinateur du D�partement/Head of Department
HEC Paris
D�partement Comptabilit� Contr�le de gestion / Dept of Accounting and Management Control
1, rue de la Liberation
78351 - Jouy-en-Josas
France
Tel: +33 1 39 67 94 42 - Fax: +33 1 39 67 70 86
[email protected]
http://campus.hec.fr/profs/stolowy/perso/home.htm
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/