My comment is a bit different. What Susan apparently user wants can be
achieved by
expand 10
sort id_psu, stable
gen no = _n
In short, the -stable- option of -sort- is intended for this purpose.
In a big dataset, that last should be
gen long no = _n
Nick
[email protected]
Martin Weiss
[...]
*************
expand 10
gen no = _n
sort id_psu no
drop no
gen no = _n
*************
is too complicated as you first have Stata record the current sort order
via
"_n" , then -sort- on "id_psu" and then -drop- "no" - only to recreate
it in
the next step.
[...]
*
* 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/