Another way of doing this, without any new variables:
bysort ID (Cost) : drop if missing(Cost[_N])
Nick [email protected]
Antoine Terracol
I would try something like :
generate tag=(cost==.)
egen toberemoved=sum(tag), by(ID)
drop if toberemoved>0
drop tag toberemoved
You will need to replace the "cost==." in the fisrt line by a more
general way to tag your erroneous values (such as "cost==. | cost>9999")
Murray Lowe
I am working with a large dataset and have discovered that
some of the data
are missing values or have erroneous values. The data is
panel data with
observations per individual over a 5 year period. For example:
ID Year Cost
1 1 100
1 2 200
1 3 500
1 4 150
1 5 x
2 1 100
2 2 200
2 3 500
2 4 600
2 5 100
The problem is this: If an individual has a missing /
erroneous value for a
particular year, I want to exclude ALL of their
observations from the
dataset. In the example patient 1 would be removed from the dataset
entirely. How can this be done through an automated-type process?
Essentially I need a code / method that looks for the
anomalous data;
identifies the patient and then removes all of their
observations from the dataset.
*
* 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/
