Very interesting question.
data have;
infile datalines;
input hms:$100.;
datalines;
7s
52s
2m9s
3m43s
10m43s
1h2m13s
;;;;
run;
data temp;
set have;
n+1;
do i=1 to countw(hms,,'kd');
vname=scan(hms,i,,'d');
value=scan(hms,i,,'kd');
output;
end;
run;
proc transpose data=temp out=want;
by n;
id vname;
var value;
run;
... View more