Help using Base SAS procedures

Coding problem using the Proc sql

Reply
New User
Posts: 1

Coding problem using the Proc sql

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.

Super User
Posts: 11,343

Re: Coding problem using the Proc sql

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

Ask a Question
Discussion stats
  • 1 reply
  • 217 views
  • 1 like
  • 2 in conversation