count Mean with SQL

[kindbe17]

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;

[PaigeMiller · Accepted solution]

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;

[kindbe17]

i have an error again;

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

[Kurt_Bremser]

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

[Oligolas]

remove the semicolons after Mean3 and sashelp.cars

[kindbe17]

Thank you