Re: st: Generating labels

[Austin Nichols <austinnichols@gmail.com>]

Or, perhaps...

clear
input year month sex str20 state municip str20 municip2
1996 11  0  Antioquia 1 Medellin
1988 7   1  Cundinam  1 Bogota
1982 4   1  Bolivar   1 ...
end
egen i=group(state municip2)
su i, mean
qui forv i=1/`r(max)' {
levelsof state if i==`i', loc(s)
levelsof municip2 if i==`i', loc(m)
loc c: di `m' ", " `s'
la def i `i' `"`c'"', modify
}
la val i i
l, noo



On Tue, Aug 27, 2013 at 3:12 PM, Sarah Edgington <sedging@ucla.edu> wrote:
> I don't think value labels will work for this task.
> If I'm understanding correctly, what Carlos wants to do is create a value
> label for municip based on the text in municip2.  The problem is that the
> values of municip2 vary within a given value of municip.  As far as I know
> there's no way to attach multiple labels to a single value that are
> different depending on the value of another variable (which is, in essence,
> what would be required for value labels to work here).
>
> What I don't understand is why the current data is problematic.  It looks
> like the string variable municip2 already contains the desired text.  I
> don't see how adding another string variable would help since it seems like
> you already have the text you need.  If what you're looking for is a numeric
> variable to represent the city names you could use -encode- to create a
> unique numeric value for every city name in the dataset.
>
> -Sarah
>
>
>
> -----Original Message-----
> From: owner-statalist@hsphsun2.harvard.edu
> [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Nick Cox
> Sent: Tuesday, August 27, 2013 11:29 AM
> To: statalist@hsphsun2.harvard.edu
> Subject: Re: st: Generating labels
>
> Sounds as if you mean _value labels_. -search labmask- and see if it does
> what you want. You need to download it before you can use it.
>
> Nick
> njcoxstata@gmail.com
>
>
> On 27 August 2013 19:22, Carlos Valencia <cavalenciah@gmail.com> wrote:
>> Hi, I'm new on stata
>>
>> I would like to add lables to some variables (or generate a new text
>> variable), which have the same code as in the example , but are in
>> fact, different, as in the example: The main city of the state
>> "Antioquia" coded by "1" is Medellin, and the main city of the state
>> "Cundinam" is 1 as well.
>>
>> YEAR MONTH SEX STATE       MUNICIP MUNICIP2
>> 1996   11           0     Antioquia  1             Medellin
>> 1988   7             1     Cundinam 1             Bogota
>> 1982   4             1     Bolivar      1             ...
>>
>> Since there are many cities belonging to some municipalities using the
>> same value, how can I handle this, without changing all the cities
>> manually?
>>
>> Thanks by your help
>> *
>> *   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/
*
*   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/