topic Vertical summation in SAS Programming

Vertical summation

Wafflecakes — Sat, 14 Oct 2017 21:29:24 GMT

I am attempting to do a column same sorted by two variables with proc sql but get the error message below:

proc sql;

create table sales as

select model, year

sum(revenue) as sum_revenue,

from carsales

Error 22-322: Syntax error, expecting one of the following: a quoted string, !, !!, &....

Error 76-322: Syntax error, statement will be ignored.

group by model, year;

run;

Have

model year revenue

acura 2013 15000

acura 2014 30000

acura 2014 150000

hyundai 2012 300000

bmw 2007 1000000

Want

model year revenue sum_revenue

acura 2013 15000 15000

acura 2014 30000 180000

acura 2014 150000 180000

hyundai 2012 300000 600000

bmw 2007 1000000 3000000

Help?

Re: Vertical summation

Reeza — Sat, 14 Oct 2017 22:41:26 GMT

You’re missing a comma after YEAR. And no commas before FROM.

Re: Vertical summation

SuzanneDorinski — Sat, 14 Oct 2017 22:43:04 GMT

You are missing a comma after year. You don't need the comma after sum_revenue.

proc sql ;
	create table want as 
	select model, 
	       year, 
	       revenue, 
	       sum(revenue) as sum_revenue 
	  from carsales 
	    group by model, year;
quit;

Re: Vertical summation

Tom — Mon, 16 Oct 2017 21:51:18 GMT

If find that you will lose track of where your commas are much less if you place them at the beginning of your continuation lines instead of at the end. It is much easier to scan the beginning of the lines of a block of code than the end of the lines.

proc sql; 
create table sales as
  select model
       , year
       , sum(revenue) as sum_revenue
  from carsales
  group by model, year
;
quit;