topic Re: Hi, can you help me detect the error? in New SAS User

Hi, can you help me detect the error?

ari2495 — Mon, 14 Nov 2022 11:35:25 GMT

Re: Hi, can you help me detect the error?

LinusH — Mon, 14 Nov 2022 12:09:59 GMT

The SELECT statement should not end with a comma.

Re: Hi, can you help me detect the error?

Astounding — Mon, 14 Nov 2022 12:37:17 GMT

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.

Re: Hi, can you help me detect the error?

ari2495 — Mon, 14 Nov 2022 12:46:45 GMT

ok thanks, so here it is, error still there

Re: Hi, can you help me detect the error?

ari2495 — Mon, 14 Nov 2022 12:54:31 GMT

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

Re: Hi, can you help me detect the error?

PaigeMiller — Mon, 14 Nov 2022 12:57:58 GMT

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.

Re: Hi, can you help me detect the error?

Tom — Mon, 14 Nov 2022 14:42:48 GMT

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?

Re: Hi, can you help me detect the error?

ari2495 — Mon, 14 Nov 2022 14:44:35 GMT

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