Announcement

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

  • How to combine the putexcel with significance symbol star

    Dear all,

    I would like combine the putexcel code with significance symbol star(*** ** *).

    Does anyone know how to yield style B instead of style A in using putexcel code?


    putexcel B4=(_b[X1])

    putexcel B5=(_b[X1]/_se[X1])


    Click image for larger version

Name:	put to excel.jpg
Views:	1
Size:	31.8 KB
ID:	1414400


    Last edited by Eric Li; 13 Oct 2017, 00:14.

  • #2
    Eric,

    You will have to create the number with the significance symbol yourself before using putexcel. For example,

    Code:
    sysuse auto, clear
    regress mpg weight turn
    local coeff = _b[turn]
    local coeff : display %5.3f `coeff' . "***"
    putexcel set test, replace
    putexcel A1 = "Coeff"
    putexcel B1 = "`coeff'"

    Comment

    Working...
    X