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
Addplot ) required error r(100);Hello world I'm working on a code to make a graph, and it keeps getting in trouble. It`s a panel d…
Nonparametric regression: lpoly vs npgressBoth commands perform local-linear kernel estimation and allow for visulizing estimates, but what ar…
Filling missing values on variables only appearing every four years in the panelHi Statalist. I have a couple of variables that only appear in waves 4, 7, 10, 14, 18 (of a panel d…
Testing for differences between groupsHello! I was tasked with proving how having the first two children of the same sex predicts whether…
Decimal places for identification variableI am merging data and some of my ID variables have decimal places. I tried using the real function b…
Subscribe to:
Post Comments (Atom)
0 Response to Help exporting to excel
Post a Comment