Export output to word or excel

[Fadzai Chikwava]

Is there a way of exporting multiple STATA outputs (bivariate regressions analyses or cross tabs) through writing STATA syntax which allows the data to display in excel or word in a single table of bivariate analysis output or descriptive table (N, %) for multiple variables. For instance, multiple bivariate analysis using weighted data as follows:

xi:logistic wellbeing i.agecat [pweight=rake_weight_final]
xi:logistic wellbeing i.sex [pweight=rake_weight_final]

[Hemanshu Kumar]

In brief: yes. In somewhat more detail: the answer will depend on which version of Stata you are on. If Stata 17 or later, take a look at the collect suit of commands, including collect export. In Stata 13 and above (I think!), you might also want to look at commands like putexcel and putdocx. And you might want to check out a number of community-contributed commands that are geared towards exporting estimation tables to documents -- esttab and outreg2 come to mind, for instance.

[Nick Cox]

Hemanshu Kumar rightly raises the question of Stata version here. Indeed, in Stata 19 and for some versions back, xi: is not only not needed, but also a source of complication.

Fadzai Chikwava Please check out point 11 in the FAQ Advice about declaring the version of Stata you're using (and while you're passing, point 18 too).