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;
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;
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;
i have an error again;
Syntax error, expecting one of the following: ',', GROUP, ORDER.
Please post the complete (all code and messages) log of the step by copy/pasting it into a window opened with this button:
remove the semicolons after Mean3 and sashelp.cars
- Cheers -
Thank you
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 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.