Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- proc sort data=work.orders_fin_tot_qtr;
- by workqtr;
- run;
- data work.orders_fin_tot_qtr;
- set work.orders_fin_tot_qtr;
- array QtrSales{4} quarter1-quarter4 ;
- do i = 1 by 1 until (last.order_id);
- if workqtr=i then QtrSales{i}=totalsales;
- end;
- drop totalsales totalprofit _TYPE_ _FREQ_;
- run;
- proc print data=work.orders_fin_tot_qtr;
- run;
Add Comment
Please, Sign In to add comment