Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: st: Generating labels
From
Carlos Valencia <[email protected]>
To
[email protected]
Subject
Re: st: Generating labels
Date
Wed, 28 Aug 2013 11:35:52 -0500
Current data is problematic because the codification of some cities is
repeated as follows: the main city of an state is codified by 1, the
second by 2 and so on. The main city of the state of Antioquia, would
be (Medellín), and is codified with 1 the main city of the state of
Cundinam (Bogota) is codified by 1 also. So, adding any label for any
single number of city would be misleading. So I wonder if there is any
way to label the number of the city, depending on the code of the
state (which is already labeled). I have tried something like (and
didn't work because of invalid syntax)
label define cityname 1 "Medellín" if state Antioquia
YEAR MONTH SEX STATE CITY CITYNAME
1996 11 0 Antioquia 1 ....
1988 7 1 Cundinam 1 ...
1982 4 1 Bolivar 1 ....
Thanks again
Carlos
On Tue, Aug 27, 2013 at 2:25 PM, Austin Nichols <[email protected]> wrote:
> 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 <[email protected]> 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: [email protected]
>> [mailto:[email protected]] On Behalf Of Nick Cox
>> Sent: Tuesday, August 27, 2013 11:29 AM
>> To: [email protected]
>> 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
>> [email protected]
>>
>>
>> On 27 August 2013 19:22, Carlos Valencia <[email protected]> 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/
--
Carlos Valencia Hernández MD
RED CHAGAS COLOMBIA
Av-Calle 26 N° 51-20 CAN
Bogotá D.C.
Tel: +571 2207700 Ext. 1315
Correo-e: [email protected]
Skype: cavalenc
*
* 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/