Here's how we can do it with PROC SQL , proc sql ;
create table test1 as
select id, DESTINATION, count(destination) as cnt
from test group by 1,2 ; quit;
proc transpose data=test1 prefix=dest_count out=test2 (drop=_name_) ;
var cnt ;
by id ;
id destination ;
run;
... View more