I don't know whether the followsing code is what you need.
try it .
[pre]
%let default_values=-999,-998,-997,999;
Data X;
input x1 x2 x3 x4$;
cards;
123 234 345 A
-999 212 999 S
453 543 -998 Q
-998 768 -997 W
;
run;
data temp;
set x(drop=x4);
array x{3};
do i=1 to 3;
if x{i} in (&default_values) then continue;
else call missing(x{i});
end;
drop i;
run;
proc transpose data=temp out=data;
run;
proc print data=data noobs;
run;
[/pre]
Ksharp
Message was edited by: Ksharp
... View more
