SAS Query

[Sundeep_M]

In sashelp there is a file name countseries (FOR SAS UNIVERSITY EDITION) , how can i make jan2004 to dec2004 into one major category as'2004 and add up all the units for 2004 and make a table consisting of only year and total units in that particular year.

Can anyone please explain this with the code.

Thank you.

[Jagadishkatam · Accepted solution]

data countseries;
set sashelp.countseries;
year=year(date);
run;

proc sql;
create table want as select year, sum(units) as sum from countseries group by year;
quit;

[Sundeep_M]

thank you sir

[Jagadishkatam]

Hi Sundeep, If it helped you, could you please mark the this as answered so it helps future users narrow down what responses to look at.

[novinosrin]

The solution should be just one pass of sql. 

A datastep to compute year and then proc sql for by group is very costly.

select clause can be used to compute year

and the computed column can be used as grouping var. 

[Jagadishkatam]

I agree  with you @novinosrin, the code could simplified in one step proc sql as below

proc sql;
create table want as select year(date) as year, sum(units) as sum from sashelp.countseries group by year;
quit;