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
Doubt on Heckprob model resultsHello everybody, I'm running a Heckman selection model based on a heckprob. I have some categorical…
Comparing two waves with RE-LogitI am currently using Panel data from the SOEP to analyze and compare political interest in 2013 and …
xtreg, fe robust: xtoverid error(2b) operator invalid when correcting Hausman test (V_b-V_B is not positive definite) due to year dummiesDear Statalisters, I am analyzing a panel dataset with year dummies over a period of 2000-2018 and …
Medeff command: invalid mediate (error r(198))Dear Statalists, Could you please tell me the reason why when I type the following command: medeff…
one year survival - data managementgood day all I have a list of children with 2 variables "date of birth" and "date of death". Both a…
Subscribe to:
Post Comments (Atom)
0 Response to Help exporting to excel
Post a Comment