Re: AW: st: Grouping variables

[Eric Booth <ebooth@ppri.tamu.edu>]

>

if you've got more than 10 cities that your assigning to a province, inlist() will hit its limit, but you can use a loop:


**
	g province = ""
	local cities b c d h i j k l m n o p q r s t 
foreach c of local cities {
	replace province = "a" if city=="`c'"
	}
**


~ Eric
__
Eric A. Booth
Public Policy Research Institute
Texas A&M University
ebooth@ppri.tamu.edu
Office: +979.845.6754



On Mar 5, 2010, at 7:26 AM, Martin Weiss wrote:

> 
> <> 
> 
> " 
> 
> gen province=a if (city=="b"|city=="c"|city=="d")
> replace province=b if (city=="e"|city=="f"|city=="g")
> 
> "
> 
> 
> 
> Those province identifiers would have to carry quotation marks around them:
> 
> 
> *************
> clear*
> inp str1 city
> a
> b
> c
> d
> e
> f
> g
> end
> 
> gen str1 province="a" if inlist(city, "b","c","d")
> replace province="b" if inlist(city, "e","f","g")
> 
> list, noo
> *************
> 
> Better still, assign numeric identifiers, and use a -value label- to
> represent the strings...
> 
> 
> HTH
> Martin
> 
> 
> -----Ursprüngliche Nachricht-----
> Von: owner-statalist@hsphsun2.harvard.edu
> [mailto:owner-statalist@hsphsun2.harvard.edu] Im Auftrag von Katya Mauff
> Gesendet: Freitag, 5. März 2010 14:00
> An: statalist@hsphsun2.harvard.edu
> Betreff: Re: st: Grouping variables
> 
> 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/