Hi everyone, I am previously an R-user and finding the functionality of STATA frustrating. I want to output a large table into Excel. The table calculates means and frequencies of age for each postcode area. I have written the following code to run the table and capture it as a matrix, and then export, but my first line of code will not work. Please help.
capture quietly table postcode, contents(freq mean age median age min age max age), matcell(X)
capture quietly matrix list X
putexcel set "C:\PROJECT\means.xlsx", sheet("age") modify
capture putexcel A1=matrix(X)
capture matrix drop X
Related Posts with Help exporting to excel
clustering robust standard errors in one wave datasetHello, I have a one wave dataset of 158 firms, is it useful to cluster the standard errors? If so, …
Margins after MixedHey all, I'm running a 2-level model using the - mixed - command. Can I use the regular - margins -…
Update to -survsim- on SSC: Simulating time-to-event data from custom distributions, competing risk models and general multi-state modelsThanks to Kit Baum, the -survsim- package has been updated on SSC. This is a complete re-write, with…
Obtaining pooled OLS estimatesI'm trying to compare Oaxaca-Blinder decomposition results to OLS estimates regarding the male wage …
Interaction effect outliers?I am very new to STATA and doing research. Something I do not quite understand. I am looking into a…
Subscribe to:
Post Comments (Atom)
0 Response to Help exporting to excel
Post a Comment