IF statement - create a new variable using if statement

[AZIQ1]

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 · Accepted solution]

Hi,

Please try this.

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

[AZIQ1]

Thank you - it worked !!!

[KachiM]

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