input
forvalues i=1(1)300 {
display `i'
clear all
display Area[1]
use "data (`i').dta"
export excel using "data (`display Area[1]' `i')", firstrow(variables) replace
}
output
1
data( 1).xls
Related Posts with To NAME: excel export using value of variable.
looking at the mean of one variable across another variableWithin stata i have data on the consumption of 10 different alcohol types. Another variable is the r…
XTSUM2DOCX: Report summary statistics of panel data to a Word tableDear all, The user-written Stata command xtsum2docx is now available on SSC, thanks to Professor Ch…
How to combine difference in difference with propensity score matching and NN matchingDear Statalisters, I am running a difference in difference and I was wondering what should I code i…
Handling of missing quality information in admetanHi David, When I run the QE model in admetan with missing quality information it still runs and pro…
Panel Data Modelling - Methodological IssuesDear Stata Users, I experience some serious confusion while working on my model due to the fact, th…
Subscribe to:
Post Comments (Atom)
0 Response to To NAME: excel export using value of variable.
Post a Comment