collapse var1 var2, by(HHID)
Daniel
> -----Original Message-----
> From: [email protected]
> [mailto:[email protected]]On Behalf Of mili
> Sent: Tuesday, October 08, 2002 9:41 PM
> To: [email protected]
> Subject: st: Re: deleting duplicate observations
>
>
> 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/
>
>
*
* 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/
