The SELECT statement should not end with a comma.
ok thanks, so here it is, error still there
in PROC SQL, in the SELECT statement, variable names should be separated by a comma. You do not have a comma there between CODICE_CLUSTER and RATING.
Don't post a photograph of the text in your SAS log! Just copy the text and post that. Use the insert code editor button to get a pop-up window to paste the text.
When writing long statements that require multiple line do NOT hide the continuation/conjunction characters as the END of the line. That makes the code difficult for humans to scan. Place such things at the start of the NEW line.
Here is code the mimic the issue in your code:
create table want as
select var1
, var2
, var3
, sum(var4) as total_var4
,
from have
group by var1
;
Can you see the problem now?
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.
Find more tutorials on the SAS Users YouTube channel.