Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: Delete data that appears "twice" ... part 2 :)


From   Markus Köller <markus-koeller@web.de>
To   statalist@hsphsun2.harvard.edu
Subject   st: Delete data that appears "twice" ... part 2 :)
Date   Mon, 25 Feb 2008 16:40:05 +0100

Thank you for your answer, Nick, but unfortunately it doesnŽt do what it should. ThatŽs why I post my problem again - sorry for bothering you all with it again.
Maybe I didnŽt explain the problem good enough in my first post:

-> 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.
!!! It is important, that it has to be deleted from 60, not from 65.!!! In Nicks answer, the data gets deleted from wave 65. But since I want to use the "fresher" or "younger" data, I want to keep the data from 65 and delete the data from 60.!!!

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.
_________________________________________________________________________
In 5 Schritten zur eigenen Homepage. Jetzt Domain sichern und gestalten! 
Nur 3,99 EUR/Monat! http://www.maildomain.web.de/?mc=021114


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



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index