you could type
drop if hhid == hhid[_n-1]
mili
----- Original Message -----
From: "Kompal Sinha" <[email protected]>
To: <[email protected]>
Sent: Monday, October 07, 2002 11:37 PM
Subject: st: deleting duplicate observations
> I have household level data in following format:
> HHID var1 var2
> 1 5 6
> 1 5 6
> 1 5 6
> 2 5 7
> 2 5 7
> 4 9 6
>
> I want it in the following format now:
> HHID var1 var2
> 1 5 6
> 2 5 7
> 4 9 6
>
> How can I retain observations with unique HHID????
>
> Thanks in advance
> Kompal
> *
> * For searches and help try:
> * http://www.stata.com/support/faqs/res/findit.html
> * http://www.stata.com/support/statalist/faq
> * http://www.ats.ucla.edu/stat/stata/
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
