data test;
infile cards missover;
input id x$;
cards;
1 a1
2
3
4 b2
5
6
7 b2
8
9 yyy7
10
11
12
13 ii100
14
15
;
run;
data test1;
set test ;
if x ne '' then aval=1;
run;
proc transpose data=test1 out=test2(drop=_name_);
by id;
id x;
var aval;
run;
data test3;
set test2;
array a(*) _numeric_;
do i=1 to dim(a);
if a(i)=. then a(i)=0;
end;
drop i;
run;