Hello,
I'm estimating a model where I have 74,000 equations, and I want to export the estimators to an excel matrix.
My loop looks like this:
putexcel set elasticities.xls, replace
foreach z of {
foreach v of num 1/273 {
display `v'
gen ln_proportion`v' = ln(proportion`v')
foreach k of num 1/273 {
display `k'
reg ln_proportion`v' p_q`v' price`v' pr`k' income
putexcel `z'`k' = e(b)
}
}
}
The problem is the outside of the loop, cause I don't know how to assign the corresponding letters to the rows on excel (A,B,C....AA,AB,AC)
I was thinking of using the tokenize command to generate the whole ABCDEFGH.... code and break it into small parts but I haven't used it before and can't figure out how to do it.
Related Posts with Export matrix to excel. How to asign rows on a loop
Are the missing values being coded as zero?Hi all, I have data on certain variables for four rounds. Following are the number of observations …
Problem with wilcoxon testDear Users, We are two undergraduate students of Economics; doing our final Thesis, and we are kind…
Rangerun SpeedHi everyone, I've been using the user-written command Rangerun to accelerate the execution of my cod…
Problem with Wilcoxon testDear Users, We are two undergraduate students of Economics; doing our final Thesis, and we are kind…
Diagnostic test in the case of longitudinal dataDear Altruist, I hope you are doing fine and in good health. I am using longitudinal data to check t…
Subscribe to:
Post Comments (Atom)
0 Response to Export matrix to excel. How to asign rows on a loop
Post a Comment