BookmarkSubscribeRSS Feed
Melaine
Calcite | Level 5

Hello folks.. I have a prblem with the SQL procedure;

I have submitted the program below but consistently get an error

proc sql;

select Gender

sum (Salary) as Total_Salary

from Work.staff

Group by Gender;

quit;

The error message is as follows

sum (Salary) as Total_Salary

     ---

     22

     76

ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, (, *, **, +, ',', -, /,

              <, <=, <>, =, >, >=, ?, AND, BETWEEN, CONTAINS, EQ, EQT, GE, GET, GT, GTT, LE,

              LET, LIKE, LT, LTT, NE, NET, OR, ^=, |, ||, ~=.

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

I need help.

1 REPLY 1
ballardw
Super User

SQL requires commas between variables on select and similar list type instructions (order by or group by)

select Gender ,

sum (Salary) as Total_Salary

from Work.staff

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 868 views
  • 1 like
  • 2 in conversation