Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
From | miriam geringer <miriam.geringer@gmail.com> |
To | statalist@hsphsun2.harvard.edu |
Subject | Re: st: Drop all that are listed in an external file |
Date | Sat, 25 Jan 2014 19:19:50 +0100 |
Thanks Lars. Good idea. It worked :) 2014-01-25 lars Folkestad <statalars@gmail.com>: > Hi > What if you merge the two files, and then use the _merge to identify what id's to keep and what do drop. > Lars > >> Den 25/01/2014 kl. 16.50 skrev miriam geringer <miriam.geringer@gmail.com>: >> >> Hi Statalist, >> >> I have the following dataset: >> >> Identifier Corresponding data >> 1 X >> 2 Z >> 3 D >> 4 >> 4 >> 4 >> 5 >> 5 >> 5 >> 5 >> 6 >> 6 >> 6 >> 7 >> 8 >> >> On the other hand, I have a *txt file, which includes only identifiers >> that should be dropped from my dataset. A simple *txt including for >> example: >> >> Identifier >> 2 >> 3 >> 4 >> >> Now, I want Stata to access this *txt file and drop all the >> observations in the dataset (based on the Identifier) that are in this >> specific *txt file. I know that I could just copy it into Stata, but >> since the list is very long I would prefer an "external" link to this >> file. >> >> After dropping, it should look like: >> >> Identifier Corresponding data >> 1 X >> 5 >> 5 >> 5 >> 5 >> 6 >> 6 >> 6 >> 7 >> 8 >> >> Is something like this possible? >> >> Something like: >> drop if identifier exists using C:/*txt >> >> Thanks! >> * >> * For searches and help try: >> * http://www.stata.com/help.cgi?search >> * http://www.stata.com/support/faqs/resources/statalist-faq/ >> * http://www.ats.ucla.edu/stat/stata/ > > * > * For searches and help try: > * http://www.stata.com/help.cgi?search > * http://www.stata.com/support/faqs/resources/statalist-faq/ > * http://www.ats.ucla.edu/stat/stata/ * * For searches and help try: * http://www.stata.com/help.cgi?search * http://www.stata.com/support/faqs/resources/statalist-faq/ * http://www.ats.ucla.edu/stat/stata/