- data b;
- set a;
- yy=year(datepart(dt));
- quarter=qtr(datepart(dt));
- run;
- proc sql noprint;
- create table res as
- select stock_code, stock_name, yy, quarter, sum(cp*vol)/sum(vol) as cost
- from b
- group by stock_code, stock_name, yy, quarter
- order by stock_code, stock_name, yy, quarter
- ;
- quit;