Many thanks, this works, now my problem is that I want to sum the number of prescriptions in each month by item_code That is, there should be a final table that has columns period, item_code and prescriptions. There should be rows of which the first rown is the column name, the second should be 01SEP2013 and the third should be 01OCT2013. The observations in the cells should be the sum of prescriptions in each month by (unique) item_code item_code sum of prescriptions 1-Sep-13 1-Oct-13 Proc sql; create table homebase.dummy3 as select item_code, sum(prescriptions) as prescriptions_sum from homebase.dummy2 group by item_code, period; quit; proc print data=homebase.dummy3; run;
... View more