The original data looks like:
data have;
input Var1 Var2 Var3 Var4;
datalines;
1 0 . 0
1 1 1 2
1 . . 3
0 2 3 1
;
I want to create a data that looks like:
1 0 . 0
1 0 0 0
1 . . 0
0 2 3 1
;
The idea is if Var1 = 1 then replace all non-missing values of Var2, Var3 and Var4 to 0 and keep missing values as-is.
EDIT: Will this work?
data want; set have;
array varlist
Var 2 Var3 Var4;
do i = 1 to 4;
if Var1 = 1 and varlist(i) ne . then varlist(i) = 0;
end; drop i; run;
EDIT 2: It turns out to work. Sorry for bringing it up.