topic Re: SAS Query in New SAS User

SAS Query

Sundeep_M — Sun, 24 Feb 2019 09:59:19 GMT

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.

Re: SAS Query

Jagadishkatam — Sun, 24 Feb 2019 10:18:54 GMT

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;

Re: SAS Query

Sundeep_M — Sun, 24 Feb 2019 11:40:38 GMT

thank you sir

Re: SAS Query

Jagadishkatam — Sun, 24 Feb 2019 12:08:30 GMT

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.

Re: SAS Query

novinosrin — Sun, 24 Feb 2019 16:36:23 GMT

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.

Re: SAS Query

Jagadishkatam — Sun, 24 Feb 2019 16:55:18 GMT

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;