Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
| From | "Katya Mauff" <Katya.Mauff@uct.ac.za> |
| To | <statalist@hsphsun2.harvard.edu> |
| Subject | Re: st: Grouping variables |
| Date | Fri, 05 Mar 2010 14:59:42 +0200 |
Dear Alejandra Try using an if statement. So for example: gen province=a if (city=="b"|city=="c"|city=="d") replace province=b if (city=="e"|city=="f"|city=="g") etc. I know it's slightly tedious, esp if you have several cities/provinces. Perhaps someone else can come up with a quicker way to do it. >>> <mmolina@uniroma3.it> 2010/03/05 02:47 PM >>> Dear Statalits, In my database I have a variable, called "city" which represent firms' main base. It is a string variable that I've already encoded in an another. I have a lot of other information about the firms and I need to work at a more aggregated level, for instance "province", could you please tell me how to assign different cities to one province? Thanks in advance. Best regards, Alejandra * * 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/ * * 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/