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 _ 22 76 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 hyundai 2012 300000 bmw 2007 1000000 bmw 2007 1000000 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 hyundai 2012 300000 600000 bmw 2007 1000000 3000000 bmw 2007 1000000 3000000 bmw 2007 1000000 3000000 Help?
... View more