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

["[iso-8859-15] Markus K�ller" <markus-koeller@web.de>]

Hello,

I have a question which I bet is easy to answer for most of you. Unfortunately, not for me. :)

-> 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.

I tried some things, but can�t get to a good solution. If anyone of you has a good idea, please post it.

Thx,
Markus.
_______________________________________
GRATIS: Movie-FLAT. Jetzt freischalten!
http://freemail.web.de/club/maxdome.htm




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