Guest User

Untitled

a guest
Dec 15th, 2018
110
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.36 KB | None | 0 0
  1. proc sort data=work.orders_fin_tot_qtr;
  2. by workqtr;
  3. run;
  4. data work.orders_fin_tot_qtr;
  5. set work.orders_fin_tot_qtr;
  6.  
  7. array QtrSales{4} quarter1-quarter4 ;
  8. do i = 1 by 1 until (last.order_id);
  9. if workqtr=i then QtrSales{i}=totalsales;
  10. end;
  11. drop totalsales totalprofit _TYPE_ _FREQ_;
  12. run;
  13. proc print data=work.orders_fin_tot_qtr;
  14. run;
Add Comment
Please, Sign In to add comment