Hello everyone,
I am in desperate need so please forgive me for not reading over the rules on how to properly post lines of code/ data examples but I've been stuck on this problem for a while. I have a dataset that has variables named numerator_jun18_1...numerator_jun18_11 all the way through numerator_apr19_1...numerator_apr19_11 and the same set-up but for denominators. Im trying to do the following function:
gen score_jun18_1 = numerator_jun18_1 / denominator_jun18_1
for all 200+ variables and am trying to do so using a for loop to save myself the 200+ lines of code and possibility for human error.
I tried the following (acknowledging that I would have to do this for at least each month/year combination)
forvalues i=1/11{
local suffix cond(`i'<10, "00`i'", "0`i'")
gen score_jun18_`suffix' = numerator_jun18_`suffix' / denominator_jun18_`suffix'
}
but received the r(198) invalid name error code. Any help would be greatly appreciated
Related Posts with Using foreach or forvalues to divide two variables
Merge DatabasesHello everyone, I'm trying to combine the following datasets (this is a subsample) DATASET 1 PHP C…
Unbalanced panel data with N>THi Everyone, I have unbalanced panel data with N=432 and T=5; I use these following command to set …
How to import data from Excel sheet to existing stata 12.0, If the data file in stata already created......!I have a created a file in Stata 12.0 and import 30 responses from Excel sheet which i have collecte…
System GMM for convergence equationsDear Statalist users, I hope this thread finds you well. I’m working with xtabond2 command in Stata…
Pair Fixed Effects in PPMLDear all, Can the pair fixed effects suggested by Baier and Bergstrand (2007) to address endogeneit…
Subscribe to:
Post Comments (Atom)
0 Response to Using foreach or forvalues to divide two variables
Post a Comment