Report suest table into microsoft words

[rozita saadan]

Hello Statalist,

I would like to do chow test for panel regression, to see whether there are differences between the two coefficient for two separate group. I use the "suest" command for that purpose.

My question is, how to report the Simultaneous results for id_developed1, id_developed2 into Microsoft word nicely? Is there any command like we use for the regression?

Below is the sample of my work. Hope someone can help me. Thank you in advance.


[CODE]
* Example generated by -dataex-. To install: ssc install dataex
clear
input float synchronicity double capitalopenness float(ln_FDI ln_equityinflows investor_protection) str4 developed
-.9979005 14.643073962797216 22.447714 21.16308 . "less"
-1.1378719 16.421969889739014 22.661797 20.58094 -1.8630208 "less"
-1.291191 20.232210722566148 22.93814 21.56452 -1.88617 "less"
-.08238697 15.164096127005259 22.70986 . -1.9093195 "less"
-2.444783 19.697724699583453 23.900806 . -2.0586386 "less"
-2.3530316 16.1290412248255 23.06683 . -2.2079577 "less"
-1.3369037 12.424415256232164 21.49621 17.253584 -3.019585 "less"
-2.440853 16.956939215560816 21.488226 . -3.8312125 "less"
-2.2450638 27.42805087554318 21.22526 17.995268 -3.39692 "less"
-2.706161 24.653455736005213 22.14026 . -3.495222 "less"
-2.3597145 23.946359886693017 22.384394 . -3.118835 "less"
-2.921395 22.0333391526542 22.43478 20.376055 -3.032939 "less"
-2.718574 19.8483841980828 22.59093 21.30265 -2.982225 "less"
-3.018254 11.021843220105149 22.998024 . -3.2836006 "less"
-3.0959916 13.738186364129437 22.11384 . -3.530075 "less"
-3.00265 15.086320352993276 23.15096 . -3.232431 "less"
-2.9838965 8.220069460593736 23.1065 . -3.08544 "less"
-3.083243 6.273966253216775 23.45268 . -3.3911765 "less"
-3.053644 9.619994838592662 23.007856 19.649963 -3.4591265 "less"
-2.7303386 11.426903268424168 22.345686 19.199545 -3.586046 "less"
end

xtset idc year

regress synchronicity capitalopenness ln_FDI ln_equityinflows investor_protection if id_developed ==1

outreg2 using myreg.doc, replace ctitle(developed1)

est store id_developed1

regress synchronicity capitalopenness ln_FDI ln_equityinflows investor_protection if id_developed ==2

outreg2 using myreg.doc, append ctitle(developed2)

est store id_developed2

**suest id_developed

suest id_developed1 id_developed2, vce(cluster idc)

test [id_developed1_mean]capitalopenness=[id_developed2_mean]capitalopenness

Thank you.

Regards,
Rozita

[Attaullah Shah]

You can use asdoc for exporting results of regressions, summary statistics, ttests, tabulations and other commands to MS word. Please note that the example data you have posted does not have several variables that you use in your codes, for example, idc, year, developed, etc.

ssc install asdoc
clear
input float synchronicity double capitalopenness float(ln_FDI ln_equityinflows investor_protection) str4 developed
-.9979005 14.643073962797216 22.447714 21.16308 . "less"
-1.1378719 16.421969889739014 22.661797 20.58094 -1.8630208 "less"
-1.291191 20.232210722566148 22.93814 21.56452 -1.88617 "less"
-.08238697 15.164096127005259 22.70986 . -1.9093195 "less"
-2.444783 19.697724699583453 23.900806 . -2.0586386 "less"
-2.3530316 16.1290412248255 23.06683 . -2.2079577 "less"
-1.3369037 12.424415256232164 21.49621 17.253584 -3.019585 "less"
-2.440853 16.956939215560816 21.488226 . -3.8312125 "less"
-2.2450638 27.42805087554318 21.22526 17.995268 -3.39692 "less"
-2.706161 24.653455736005213 22.14026 . -3.495222 "less"
-2.3597145 23.946359886693017 22.384394 . -3.118835 "less"
-2.921395 22.0333391526542 22.43478 20.376055 -3.032939 "less"
-2.718574 19.8483841980828 22.59093 21.30265 -2.982225 "less"
-3.018254 11.021843220105149 22.998024 . -3.2836006 "less"
-3.0959916 13.738186364129437 22.11384 . -3.530075 "less"
-3.00265 15.086320352993276 23.15096 . -3.232431 "less"
-2.9838965 8.220069460593736 23.1065 . -3.08544 "less"
-3.083243 6.273966253216775 23.45268 . -3.3911765 "less"
-3.053644 9.619994838592662 23.007856 19.649963 -3.4591265 "less"
-2.7303386 11.426903268424168 22.345686 19.199545 -3.586046 "less"
end

gen idc = 1
gen year = _n+2000
xtset idc year
asdoc regress synchronicity capitalopenness ln_FDI ln_equityinflows investor_protection , nest replace
est store id_developed1
asdoc regress synchronicity capitalopenness ln_FDI ln_equityinflows investor_protection, nest
est store id_developed2
asdoc suest id_developed1 id_developed2

The above asdoc commands produce the following output.

[rozita saadan]

Dear Prof. Attaullah Shah ,

Many thanks for the codes above. They work very well.