current working code:
data m2 m3;
set m1;
if substr(d_c_p1,1,3) = 'o9' or substr(d_c_p2,1,3) = 'o9' or substr(d_c_p3,1,3) = 'o9'
or substr(d_c1,1,3) = 'E8' or substr(d_c2,1,3) = 'E8'
or substr(d_c3,1,3) = 'E8' or substr(d_c4,1,3) = 'E8' or substr(d_c4,1,3) = 'E8' or substr(d_c5,1,3) = 'E8' or substr(d_c6,1,3) = 'E8'or substr(d_c7,1,3) = 'E8' then output m3;
else output m2;
run;
The one I modify but does not work so far.
array d_c_p{3}d_c_p1-d_c_p3;
do i=1 to 3;
if substr(d_c_p{i},1,3) = 'o9' then do output=m3; end;
array dx_code{7}d_c1-d_c7;
do j=1 to 7;
if substr(d_c{j}, 1,3)='E8' then do output=m3; end;
end;end;
else output m2;
the error message is:
: No matching IF-THEN clause
for the else output m2
please give advice how to correct thanks
... View more
