Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • table results interpretation and how to export

    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

  • #2
    Code:
    help collect export

    Comment


    • #3
      solved...Thank you

      Comment

      Working...
      X