Is this what you are looking for ? data have;
input ID $ Date Type $;
datalines;
1 20111111 A
2 20081014 C
3 20051126 A
100 20160421 B
;
run;
proc sort data=have;
by id;
where type in ('A','B');
run;
Proc transpose data=have out=want(drop=_name_ ) prefix=dateof;
id type;
by id;
var date;
run;
... View more