i need the output as below,can anyone help me
id profit1 profit2 profit3 profit4 revenue1 revenue2 revenue3 revenue4
1 2 5 7 9 10 20 30 40
2 3 8 . . 3 8 .
.
Data I have
Data have;
input id serial Revenue profit;
cards;
1 1 10 2
1 2 20 5
1 3 30 7
1 4 40 9
2 1 5 3
2 2 10 8
2 3 . .
2 4 . .
;
Run;
proc print; run;
... View more