Dear using this command below
The results in talbe: The first columm is mean of variable MCAP or difference of mean of Two sample?
How to export to word?
Is possible to export using asdocx?
label define CATH 0 "Non-Chatolic" 1 "Chatolic"
label values CATH CATH
label define PROT 0 "Non-PROT" 1 "PROTEST"
label values PROT PROT
drawnorm x1-x18
label var x1 MCAP
label var x2 INDEX
label var x3 PD
label var x4 IND
label var x5 MAS
label var x6 UAI
label var x7 LTO
label var x8 CATH
label var x9 ISLA
label var x10 PROT
label var x11 EAST
label var x12 MO
label var x13 Value
label var x14 SAVING
label var x15 PRIVAT
label var x16 FDI
label var x17 LDG
label var x18 PC1
* collect results
foreach x of varlist x* {
ttest `x', by(CATH)
collect get mean=(r(mu_1)), tags(var[`x'] CATH[0])
collect get mean=(r(mu_2)), tags(var[`x'] CATH[1])
collect get t=(r(t)) p=(r(p)), tags(var[`x'] CATH[_hide])
ttest `x', by(PROT)
collect get mean=(r(mu_1)), tags(var[`x'] PROT[0])
collect get mean=(r(mu_2)), tags(var[`x'] PROT[1])
collect get t=(r(t)) p=(r(p)), tags(var[`x'] PROT[_hide])
}
* define the rules for significance labels
collect stars p .1 "*" .01 "**" .001 "***" , attach(t) dimension
collect layout (var) (CATH#result#stars PROT#result#stars)
* select results to show in table
collect style autolevels result mean t, clear
* change display order of grouping variables
collect style autolevels CATH 1 0 _hide
collect style autolevels PROT 1 0 _hide
* label the test statistic
collect label levels result t "Test t", modify
* hide column labels for the mean
collect style header result[mean], level(hide)
* left align the stars labels
collect style cell stars[label], halign(left)
* other misc style choices
collect style cell result[mean t], nformat(%9.3f)
collect style cell border_block[corner row-header], ///
border(right, pattern(none))
collect style column, dups(center)
collect previewpanel B stata.pdf
The results in talbe: The first columm is mean of variable MCAP or difference of mean of Two sample?
How to export to word?
Is possible to export using asdocx?
label define CATH 0 "Non-Chatolic" 1 "Chatolic"
label values CATH CATH
label define PROT 0 "Non-PROT" 1 "PROTEST"
label values PROT PROT
drawnorm x1-x18
label var x1 MCAP
label var x2 INDEX
label var x3 PD
label var x4 IND
label var x5 MAS
label var x6 UAI
label var x7 LTO
label var x8 CATH
label var x9 ISLA
label var x10 PROT
label var x11 EAST
label var x12 MO
label var x13 Value
label var x14 SAVING
label var x15 PRIVAT
label var x16 FDI
label var x17 LDG
label var x18 PC1
* collect results
foreach x of varlist x* {
ttest `x', by(CATH)
collect get mean=(r(mu_1)), tags(var[`x'] CATH[0])
collect get mean=(r(mu_2)), tags(var[`x'] CATH[1])
collect get t=(r(t)) p=(r(p)), tags(var[`x'] CATH[_hide])
ttest `x', by(PROT)
collect get mean=(r(mu_1)), tags(var[`x'] PROT[0])
collect get mean=(r(mu_2)), tags(var[`x'] PROT[1])
collect get t=(r(t)) p=(r(p)), tags(var[`x'] PROT[_hide])
}
* define the rules for significance labels
collect stars p .1 "*" .01 "**" .001 "***" , attach(t) dimension
collect layout (var) (CATH#result#stars PROT#result#stars)
* select results to show in table
collect style autolevels result mean t, clear
* change display order of grouping variables
collect style autolevels CATH 1 0 _hide
collect style autolevels PROT 1 0 _hide
* label the test statistic
collect label levels result t "Test t", modify
* hide column labels for the mean
collect style header result[mean], level(hide)
* left align the stars labels
collect style cell stars[label], halign(left)
* other misc style choices
collect style cell result[mean t], nformat(%9.3f)
collect style cell border_block[corner row-header], ///
border(right, pattern(none))
collect style column, dups(center)
collect previewpanel B stata.pdf
Comment