I am currently experimenting with "putexcel" on STATA16.
I have no problem reporting the results of a simple tabulation but when I want to add the percentages in columns it gets complicated.
I would like to have my Excel file in this form:
No additionnal time | Additionnal time | p-value | |||
N | % | N | % | ||
Sexe | 0,687853 | ||||
Male | 201 | 58.60 | 459 | 57.74 | |
Female | 142 | 41.40 | 336 | 42.26 |
putexcel A7="Sexe", bold
tab I_SEXE class_add_time0, missing col chi2 matcell(freq)
putexcel B8=matrix(freq)
putexcel F7=matrix(r(p))
putexcel A8="Male" A9="Female"
No additionnal time | Additionnal time | p-value | |||
N | % | N | % | ||
Sexe | 0,786233 | ||||
Male | 201 | 459 | |||
Female | 142 | 336 |
Yours sincerely
Joséphine
0 Response to puexcel with command tabulate
Post a Comment