topic Re: count Mean with SQL in SAS Programming

count Mean with SQL

kindbe17 — Wed, 03 May 2023 12:46:43 GMT

how can i fix the syntax error?

proc sql;
create table cars11 as
select make,
type,
Mean (horsepower) as Mean1,
Mean (invoice) as Mean2,
Mean (weight) as Mean3,
From sashelp.cars,
Group by make, type;
quit;

Re: count Mean with SQL

PaigeMiller — Wed, 03 May 2023 12:57:48 GMT

No comma after the last variable name and before FROM

Also no comma after FROM SASHELP.CARS

proc sql;
    create table cars11 as
    select make,
       type,
       Mean (horsepower) as Horsepower_Mean,
       Mean (invoice) as Invoice_Mean,
       Mean (weight) as Weight_Mean
    from sashelp.cars
    group by make, type;
quit;

Pro tip: putting the commas before the variable in PROC SQL and indenting the code helps eliminate the first error, which is a common error

proc sql;
    create table cars11 as select 
       make
       ,type
       ,Mean (horsepower) as Horsepower_Mean
       ,Mean (invoice) as Invoice_Mean
       ,Mean (weight) as Weight_Mean
    from sashelp.cars
    group by make, type;
quit;

Re: count Mean with SQL

Oligolas — Wed, 03 May 2023 12:53:04 GMT

remove the semicolons after Mean3 and sashelp.cars

Re: count Mean with SQL

kindbe17 — Wed, 03 May 2023 12:54:21 GMT

i have an error again;

Syntax error, expecting one of the following: ',', GROUP, ORDER.

Re: count Mean with SQL

kindbe17 — Wed, 03 May 2023 12:55:35 GMT

Thank you

Re: count Mean with SQL

Kurt_Bremser — Wed, 03 May 2023 13:52:22 GMT

Please post the complete (all code and messages) log of the step by copy/pasting it into a window opened with this button: