st: RE: [iso-8859-15] Delete data that appears "twice" in a mixture of panel[iso-8859-15] - and crosssectional data

["Nick Cox" <n.j.cox@durham.ac.uk>]

replace Id = Id60 if Id60 < . 
duplicates drop Id, force  

Nick 
n.j.cox@durham.ac.uk 

Markus K�ller

-> I am using a mixture of paneldata and cross-sectional data which is organized in the following form:

Id   Wave   Age    Gender ..... etc...    Id60

1     60                                                 .
2     60                                                 .
3     60                                                 .
4     65                                                 .
5     65                                                 1  
6     65                                                 .  
.
.
.
etc....

To continue my analysis, I will have to delete the households from wave "60", which also appear in the "later" wave.
In other words, I have to delete the data in a way, that the above  table looks like:

 Id   Wave   Age    Gender ..... etc...    Id60

2     60                                                 .
3     60                                                 .
4     65                                                 .
5     65                                                 1  
6     65                                                 .  
.
.
.
etc....

, because household "1" also appears in 65-wave.


*
*   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/