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
How does the PPML command check for overfitting?Dear all, I have a question about the procedure how the PPML command is checking for overfitting. I…
Mata compiler ignores eltypes / orgtypes for variable declarationsHi, I was surprised to see that the Mata compiler seems to ignore much of the eltype and orgtype sp…
Identifier with huge codesHallo everybody and thanks in advance for any kind of suggestion. I am working on a large dataset ab…
Python 3.8, error r(7100)I have been trying out the latest release of Python, 3.8.0, but when I try to use it I get the follo…
Robust standard errors - OLS - Right-skewed distributionHi, I am looking at data for returns of companies after their initial public offering. The return-d…
Subscribe to:
Post Comments (Atom)
0 Response to Help exporting to excel
Post a Comment