Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down on April 23, and its replacement, statalist.org is already up and running.


[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 <njcoxstata@gmail.com>
To   statalist@hsphsun2.harvard.edu
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 <ameen_vet@yahoo.com> 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 <richgold@ix.netcom.com>

> 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/


© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index