Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
From | Fatma Usheva <fatmausheva@gmail.com> |
To | statalist@hsphsun2.harvard.edu |
Subject | st: Replace observations within variables |
Date | Thu, 19 Sep 2013 12:37:40 +0200 |
Dear All, I have a dataset with more than 400 variables, which have a common prefix, e.g. data_0, data_1, data_2, etc. I also have state and municipality IDs, where within a state I could have multiple municipalities. What I want to do is to replace observations within data_* variables for selected municipalities only, keeping state municipality codes unchanged. The way i do it now is the following: foreach var of varlist data_* { capture noisily replace `var'=`var'[11] if municipality==2001 capture noisily replace `var'=`var'[16] if municipality==26043 } where under [11] is municipality 2002, under [16] is municipality 3003, etc. Is there a faster way to do this, without me going through the data trying to find which observation number corresponds to each municipality in interest (2002, 3003, 4003, etc.)? Thanks for your help! Fatma * * 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/