这个凑活着用吧
data a;
input x1 x2 x3 x4 x5;
cards;
1 2 3 6 7
. 2 6 4 6
. . 9 . 5
;
run;
proc transpose data=a out=b;run;
data b;set b;id=_n_;run;
Data d;Set b(drop=_name_);
Array Numr _all_;
Do Over Numr;
If Numr in(.) Then delete;
End;Run;
proc sql noprint;
create table c as
select * from b
where exists
(select * from d where d.id=b.id)
;quit;
proc transpose data=c(drop=id) out=final(drop=_name_);run;