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, 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 <>
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",

No strong advantage to either, except concision.


On Wed, Sep 5, 2012 at 5:55 PM, Shittu, Aminu <> 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 <>

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

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