topic Re: Create a new variable based on the value of another variable in SAS Data Management

Create a new variable based on the value of another variable

AnnaNZ — Sun, 25 Jun 2017 23:13:11 GMT

I want to create a new variable based on specidif conditions. If the conditions are met, I want that new variable to carry the value that is in a different variable:

Example

IF (ROLE_IN_REFERRAL = 'x' or    
ROLE_IN_REFERRAL = 'y' or  
ROLE_IN_REFERRAL = 'z')
THEN AGE_AT_RFRL_CHLD = 

use the value(in this case the age)  that is in variable: (age_at_referral) 
ELSE AGE_AT_RFRL_CHLD = . ;
run;

Re: Create a new variable based on the value of another variable

TomKari — Sun, 25 Jun 2017 23:20:30 GMT

This is pretty straightforward, but two questions first:

1. Which SAS environment are you trying to do this in (Base SAS, Enterprise Guide, DI Studio, ...).

2. It looks like ROLE_IN_REFERRAL is character, and age_at_referral and AGE_AT_RFRL_CHILD are both numeric. Please confirm.

Tom

Re: Create a new variable based on the value of another variable

AnnaNZ — Sun, 25 Jun 2017 23:25:36 GMT

Hi Tom

I work with SAS9.4

and yes ROLE_IN_REFERRAL is character, and age_at_referral and AGE_AT_RFRL_CHILD are both numeric

Re: Create a new variable based on the value of another variable

kiranv_ — Mon, 26 Jun 2017 00:42:41 GMT

IF ROLE_IN_REFERRAL in( 'x', 'y' , 'z')
THEN AGE_AT_RFRL_CHLD = age_at_referral;
ELSE AGE_AT_RFRL_CHLD = . ;