[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

st: RE: Not sorted error in forvalues loop

From   "Nick Cox" <>
To   "Nick Cox" <>, <>
Subject   st: RE: Not sorted error in forvalues loop
Date   Mon, 5 Oct 2009 17:02:45 +0100

Apologies for previous premature post. 

My guess: 

Second time round the loop, your data start out sorted -id difa1-. But
you then ask to do things -by id treated:-. Those two aren't consistent.

The first line in your loop should perhaps be 

bysort id treated : ... 


Dorothy Bridges

Stata stops the following loop with a "not sorted" line after the
"sort id difa`i'" command (not after the subsequent command, after the
sort command).  What am I missing?  Thanks!!

forvalues i = 1/5 {
by id treated: gen var_a`i'=.
replace var_a`i'=ln_var if ante_`i'==1
by id treated: egen var_a`i'_mean=mean(var_a`i')
gen difa`i'=.
replace difa`i'=var_a`i'_mean - var_a`i'_mean[_n-1] if id==id[_n-1]
replace difa`i'=. if difa`i'==0
sort id difa`i'
replace difa`i'=difa`i'[_n-1] if difa`i'==. & id==id[_n-1]

*   For searches and help try:

© Copyright 1996–2017 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index