Thanks, Scott. The code works and it's exactly what I had wanted.
Oliver, your codes look reasonable to me too but when I run them, only
the first obs is filled in with values for the two newly-generated
variables. I will try to figure it out.
Joerg, yes, my weight variables are sorted for each obs, but your
codes are illuminating and I learned from them too.
Guys, thanks for all your help!
Kind regards,
Daifeng
On Wed, Jul 13, 2011 at 2:56 PM, Scott Merryman
<scott.merryman@gmail.com> wrote:
Like this?
clear
input v1 v2 v3 v4 v5 v6 v7
.96 .04 .0 0 0 0 0
.5 .3 .1 .03 .03 .03 0.01
.4 .2 .2 .15 .03 0.015 .002
.3 .3 .37 .03 0 0 0
.9 .08 .02 0 0 0 0
end
gen sum = 0
gen var_count = 1
qui {
forv i = 1/7 {
replace sum = sum + v`i' if sum<.95
replace var_count = var_count + 1 if sum<.95
}
}
l
Scott
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
