Hi everybody
I am new to programming in stata and need some help to run a loop.
I have a dataset with more than 600 variables and 1300 observations.
I know you prefer real data, however, I cant load an example of my data, as I work on a remote server, but I can provide a simple example to illustrate my case:
My data is built upon 3 types of variables which are connected. All _1 is connected, all _2 and so on.
I want to do something like this:
I have done something like the code beneath, but it do not keep the variables together (_1 with _1 and so forth) or in order (it is important that the first sum is evaluating first a_1*e_1, then b_2*f_2, then c_3*g_3 and then d_4*h_4 until x is reached, and stop, if one more variable exceed x) and the second "loop" do not stop at the max variable from first “loop” (it should also evaluate in order from variable i to l):
vl create omk = (a_1 b_2 c_3 d_4)
vl create pot = (e_1 f_2 g_3 h_4)
vl create eff = (i_1 j_2 k_3 l_4)
gen omk = 0
gen omk_temp = 0
gen eff = 0
foreach i of varlist $omk {
foreach v of varlist $pot {
foreach y of varlist $eff {
replace omk_temp = omk_temp + `i’ * `v’
replace omk = omk + `i’ * `v’ if omk_temp <= x
replace eff = eff + `y’ * `v’ if omk_temp <= x
}
}
}
The result should for the example be:
It might be the wrong way to go, and "while" could be an opportunity.
Hope you have some kind of suggestion.
All the best,
Line
I am new to programming in stata and need some help to run a loop.
I have a dataset with more than 600 variables and 1300 observations.
I know you prefer real data, however, I cant load an example of my data, as I work on a remote server, but I can provide a simple example to illustrate my case:
| id | a_1 | b_2 | c_3 | d_4 | e_1 | f_2 | g_3 | h_4 | i_1 | j_2 | k_3 | l_4 | x |
| 1 | 2 | 2 | 5 | 6 | 2 | 1 | 9 | 4 | 3 | 4 | 5 | 6 | 34 |
| 2 | 3 | 2 | 6 | 9 | 9 | 5 | 3 | 9 | 6 | 4 | 8 | 1 | 55 |
| 3 | 9 | 4 | 1 | 1 | 5 | 7 | 6 | 5 | 4 | 1 | 1 | 8 | 87 |
I want to do something like this:
- If a_1 * e_1 <x then do a_1 * e_1 + b_2 *f_2 else stop. If a_1 * e_1 + b_2 *f_2 <x then do a_1 * e_1 + b_2 *f_2 + c_3*g_3, else stop and soforth until ….. + d_4*h_4 if <= x then stop else stop at the step before. (for id1 the loop should stop at a_1*e_1 + b_2*f_2 = 6 < 34, adding the next pair of variables c_3*g_3 make the sum exceed 34).
I have done something like the code beneath, but it do not keep the variables together (_1 with _1 and so forth) or in order (it is important that the first sum is evaluating first a_1*e_1, then b_2*f_2, then c_3*g_3 and then d_4*h_4 until x is reached, and stop, if one more variable exceed x) and the second "loop" do not stop at the max variable from first “loop” (it should also evaluate in order from variable i to l):
vl create omk = (a_1 b_2 c_3 d_4)
vl create pot = (e_1 f_2 g_3 h_4)
vl create eff = (i_1 j_2 k_3 l_4)
gen omk = 0
gen omk_temp = 0
gen eff = 0
foreach i of varlist $omk {
foreach v of varlist $pot {
foreach y of varlist $eff {
replace omk_temp = omk_temp + `i’ * `v’
replace omk = omk + `i’ * `v’ if omk_temp <= x
replace eff = eff + `y’ * `v’ if omk_temp <= x
}
}
}
The result should for the example be:
| Id | omk | eff |
| 1 | 6 | 10 |
| 2 | 55 | 98 |
| 3 | 84 | 73 |
Hope you have some kind of suggestion.
All the best,
Line
