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 new variable with new values from the old one
From
Nick Cox <[email protected]>
To
[email protected]
Subject
Re: st: Generating new variable with new values from the old one
Date
Wed, 5 Sep 2012 20:36:03 +0100
You can do this:
gen agecat = age_category
replace agecat = "UNKNOWN" if inlist(agecat, "NA", "NONE", "OTHER")
or even this
gen agecat = cond(inlist(agecat, "NA", "NONE", "OTHER"), "UNKNOWN",
age_category)
No strong advantage to either, except concision.
Nick
On Wed, Sep 5, 2012 at 5:55 PM, Shittu, Aminu <[email protected]> wrote:
> Thanks very much! The following works for me:
>
> gen agecat=age_category
> replace agecat="UNKNOWN" if agecat=="NA"
> replace agecat="UNKNOWN" if agecat=="NONE"
> replace agecat="UNKNOWN" if agecat=="OTHER"
From: Richard Goldstein <[email protected]>
> when you type "gen agecat=." you are setting up a numeric variable (be
> careful of the typo in your code below)
>
> however, "adult" is not a number
>
> further if the entries in age_category are in caps, your statement needs
> to be in caps also
>
> you are probably better off by using (1) encode to get a new numeric
> variable and then (2) recode or a replace to change the values you want
> to change
On 9/5/12 11:11 AM, Shittu, Aminu wrote:
>> I am interested in generating a new "agecat" variable and then rename every value in the original "age_category" named "NA," "NONE" and "UNKNOWN" to mean the same, I will call all of the as "NONE." However, I am interested in keeping those values such as "ADULT," and "YOUNG" to mean the same as in the original "age_category" variable. I used the following initially but the response is always "adult not found," is there a way I can do it in Stata? Here are my command lines:
>>
>> gen agacat=.
>> replace agecat=adult if age_category==adult
>>
>> Please note all the entries in var "age_category" are in CAPS.
*
* 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/