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.