Similar idea but using more of the transpose options to clean things up:
data asd;
input pol_key polsyskey Qutokey Predicted Month Addition;
datalines;
1 2 3 0.5 1 1
1 2 3 4.5 2 1
1 2 3 10.9 3 1
;
run;
proc sort data=asd;
by pol_key polsyskey Qutokey;
run;
proc transpose data=asd out=mtrans (drop=_name_)
prefix=P;
by pol_key polsyskey Qutokey;
var predicted;
id month;
run;
proc transpose data=asd out=atrans (drop=_name_)
prefix=Add;
by pol_key polsyskey Qutokey;
var Addition;
id month;
run;
data want;
merge mtrans atrans;
by pol_key polsyskey Qutokey;
run;
... View more
