Try double-transpose: (1) transpose by type, (2) by _name_:
data have;
input type $ exec_time;
cards;
xml 35
xml 97
xml 110
xml 250
xml 190
xml 110
xml 600
zip 10
zip 44
zip 65
zip 77
zip 43
zip 44
;
run;
proc transpose data=have out=have_trx;
by type;
var exec_time;
run;
proc transpose data=have_trx out=want(drop=_name_);
by _name_;
id type;
var col:;
run;
... View more
