topic IF statement - create a new variable using if statement in SAS Programming

IF statement - create a new variable using if statement

AZIQ1 — Fri, 15 Jul 2016 18:06:14 GMT

I want to update var1 with the next available var2,3 or 4 value?

Have:

Var1 var2 var3 var4

1 . 1 1

. . . 2

2 1 1 .

. 1 . .

Want :

Var1 var2 var3 var4

1 . 1 1

2 . . 2

2 2 2 .

1 1 . .

Thanks

stat_sas — Fri, 15 Jul 2016 18:12:26 GMT

Hi,

Please try this.

data want;
set have;
Var1=coalesce(var1,var2,var3,var4);
run;

AZIQ1 — Fri, 15 Jul 2016 18:16:26 GMT

Thank you - it worked !!!

KachiM — Fri, 15 Jul 2016 18:30:55 GMT

It looks that the solution provided to you gets Var3 in the 4-th observation to 2. I guess I am doing something wrong.