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.
Recode categorical variable with 83 categoriesHello, Thanks for any help in advance.Very much a beginner, so apologies if this is very basic. I am…
lincom and nlcom commandsHi Dear, Can you please tell me if there is a maximum limit on the number of coefficients which can…
Why and when is panel data preferrable to pooled cross-sectional?Not sure if non-Stata econometric questions are welcome here, but I've encountered an issue at work.…
Dropping "old/updated" observationsI have the following issue: I want to merge Dataset 1 with Dataset 2. One uses SEDOL as Identifier, …
I want to divide the numlist in two groups.Hi, I have a loop with 50 values "foreach j of numlist 1/50 {", and I want to divide the numlist i…
Subscribe to:
Post Comments (Atom)
0 Response to To NAME: excel export using value of variable.
Post a Comment