Hi, can you help me detect the error?

[ari2495]

[LinusH · Accepted solution]

The SELECT statement should not end with a comma.

[ari2495]

ok thanks, so here it is, error still there 

[PaigeMiller]

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.

[Astounding]

Also note, the name of a SAS data set does not require quotes around it. The CREATE TABLE name is correct but the FROM name is not.

[ari2495]

ok thanks, so here it is, error still there
please see screenshot on the comment above

[Tom]

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?

[ari2495]

thank you. so sorry, i'm learning...