其实这个很简单,转置一下就行了;
data a;
input stk $ time $ c ;
cards;
000001 192801 0.3
000001 192802 0.4
000001 192803 0.3
000001 192804 0.4
000001 192805 0.3
000001 192806 0.4
000001 192807 0.3
000001 192809 0.4
000002 192801 0.3
000002 192802 0.8
000002 192804 0.4
000002 192805 0.3
000002 192806 0.4
000002 192807 0.3
000002 192808 0.4
;
run;
proc sort data= a out=b ;
by stk time;
run;
proc transpose data=b out=c name= var label= varlist ;
id time;
by stk;
var c;
run;
proc transpose data=c out=d (rename=(_name_=time col1=C));
by stk ;
var _:;
run;
data final;
set d;
time= strip(tranwrd(time,'_',''));
label time= 'Time';
run;