Hi Forum,
I have tried this loop (see below) ten thousand times and something really strange happens. The loop is bigger than shown, but I think it is sufficient to formulate my question.
After the number 2., I have a esttab where I can see my regression results where the two scalars marked in bold are shown. However, my problem is that only one scalar appears in my excel sheet, and the other in blank, and it is always the first one in order. So, when I change the order of the two scalars (e.g. I put number 2. first and then 1.), I get the first scalar result on my regression sheet and the other in blank. I have no idea why this happens, but it would be great if someone has any suggestions for this problem.
local i = 0
forval i = 1/${_`sgm'_ct}{
forval j = 1/$controls_ct {
forval t = 1/$r {
*1. Compute lower bound
cap gen x_`i'_`j'_`t' = (((invttail(e(df_r),0.05)* _se[flag] * flag)*NumberOfProducts_`i'_`j'_`t')/TotalSales_`i'_`j'_`t')*100
su x_`i'_`j'_`t' if e(sample) & flag_ == 1
estadd scalar x = r(mean)
*2. Compute and test
cap gen y_`i'_`j'_`t' = (((flag_ * _b[flag])*NumberOfProducts_`i'_`j'_`t')/TotalSales_`i'_`j'_`t')*100
su y_`i'_`j'_`t' if e(sample) & flag_== 1
estadd scalar y = r(mean)
}
}
}
Many thanks in advance!
Best regards,
Lena
Related Posts with Loop - Forvalues - works in different order
Fixed Effects Regression - Binary Variable Can Only Equal 1 OnceDear all, I am working with a dataset looking at employee departures across a group of firms. The d…
Questions on the validity of a dynamic model of the Second-Order [using XTABOND2 command] My data is structured as follows Code: * Example generated by -dataex-. For more info, type help …
Calculating days elapsed between dates in Panel dataHello guys, I am trying to calculate days elapsed for each 'episode' between x and y values. For ex…
ImportError after specifying set python_exec in Python integrationHello If I set a certain environment's executable for python, initialize it and import a package in…
Unable to find detailed parameters for variablesHello everyone, I am using Stata /SE 17.0 working with the Pollock 2012 data set states.dta. I am ha…
Subscribe to:
Post Comments (Atom)
0 Response to Loop - Forvalues - works in different order
Post a Comment