Recode multiple variables

aowais — Fri, 12 Jul 2019 18:16:56 GMT

Hi All,

I need to recode a set of 8 variables into a single variable, such that if all 8 are missing then the new variable is missing, but if even one of the variable = '1' then the new variable = '1'; else the new variable = '0'. I know how to that in long hand (see below), but was wondering is there was a better way to do this.

data two; set one;

if var1 = . and var2 = . and var3 = . and var4 = . and var5 = . and var6 = . and var7 = . and var8 = . then new_var = .;

else if var1 = 1 or var2 = 1 or var3 = 1 or var4 = 1 or var5 = 1 or var6 = 1 or var7 = 1 or var8 = 1 then new_var = 1;

else new_var = 0;

run;

Re: Recode multiple variables

Tom — Fri, 12 Jul 2019 18:24:56 GMT

As long as you know the values are 0/1 then just take the max.

new_var=max(of var1-var8);

Re: Recode multiple variables

aowais — Fri, 12 Jul 2019 18:30:34 GMT

Thanks! It works!

topic Re: Recode multiple variables in SAS Programming

Recode multiple variables

Re: Recode multiple variables

Re: Recode multiple variables