if condition - create new variable

AZIQ1 — Wed, 20 Jul 2016 17:08:15 GMT

Hi,

I want to create a new variable (newvar) based on conditional logic see below - i know this would be easy but I need help.

have:

var1 var2 var3 var4 var5 var6

1 1 0 a b c

1 1 1 b b c

0 1 1 d b c

1 0 0 a b c

1 0 1 b a c

want:

var1 var2 var3 var4 var5 var6 newvar

1 1 0 a b c 1 (if var4 or var5 =a and var1 or var2 =1 then newvar=1)

1 1 1 b b c 0

0 1 1 d b c 0

1 0 0 a b c 1

1 0 1 b a c 1

thanks

Re: if condition - create new variable

KachiM — Tue, 26 Jul 2016 17:19:41 GMT

It is easy. Catch the logical value of those joint conditions. It takes 1 when true zero otherwise.

data have;
input var1  var2   var3   var4 :$1.  var5 :$1.  var6 :$1.;
datalines; 
1   1   0    a   b   c 
1   1   1    b   b   c 
0   1   1    d   b   c 
1   0   0    a   b   c 
1   0   1    b   a   c 
;
run;


data want;
   set have;
   newvar = (var4 = 'a' | var5 = 'a') & (var1 = 1 | var2 = 1);
run;

topic if condition - create new variable in SAS Programming

if condition - create new variable

Re: if condition - create new variable