Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
From | Jeph Herrin <stata@spandrel.net> |
To | statalist@hsphsun2.harvard.edu |
Subject | Re: st: Identify and Replace Values |
Date | Mon, 12 Jul 2010 13:52:46 -0400 |
how about levelsof traded_model, local(traded) levelsof new_model, local(new) local onlytraded : list traded - new local onlynew : list new - traded local others : list onlynew | onlytraded replace traded_model="others" if inlist(traded_model,"`others'") replace new_model ="others" if inlist(new_model,"`others'") hth, Jeph On 7/12/2010 12:18 PM, Hobst wrote:
Hello I have a huge dataset containing automotive brand-swiching data. I have a variable called traded_model and another variable called new_model. in order to output a symmetric swiching matrix i need to identify all the expressions that are eigther only in traded_brand or only in new_brand and replace the expression with "others". For example a model called "318d" exists in traded_model but not in new_model, so all the "318d" should be replaced by "others". Does anyone have an idea how i can programm that? I dont get it to work, and doing it manually is close to impossible as there are more than 1000 different model names. Any help is much appreciated, thank you.
* * For searches and help try: * http://www.stata.com/help.cgi?search * http://www.stata.com/support/statalist/faq * http://www.ats.ucla.edu/stat/stata/