topic Re: syntax errors with proc sql in SAS Procedures

syntax errors with proc sql

lmyers2 — Mon, 02 Mar 2020 07:14:09 GMT

Hello - I'm using SAS 9.4 and am simply trying to use proc sql to make a table that is grouped and in a certain order but am getting syntax errors that I can't figure out. Below is the code and attached is the screenshot of the errors.

PROC SQL;
create table by_specialty as
SELECT  SumIndemnityCPI,PRIMARY_RESPONSIBLE_PROVIDER,
from finalfinalfile,
GROUP BY PRIMARY_RESPONSIBLE_PROVIDER,
order by SumIndemnityCPI,
QUIT;

Re: syntax errors with proc sql

andreas_lds — Mon, 02 Mar 2020 07:20:19 GMT

Remove the comma after primary_responsible_provider. For the next post: please don't post log as screenshot but as text using the {i}-icon.

Re: syntax errors with proc sql

Kurt_Bremser — Mon, 02 Mar 2020 07:23:12 GMT

All commas at the ends of your code lines are invalid.

Re: syntax errors with proc sql

Astounding — Mon, 02 Mar 2020 07:25:28 GMT

The final comma should be a semicolon.

Re: syntax errors with proc sql

ed_sas_member — Mon, 02 Mar 2020 08:35:57 GMT

Hi @lmyers2

To sum up all comments:

PROC SQL;
	create table by_specialty as
	SELECT  SumIndemnityCPI,PRIMARY_RESPONSIBLE_PROVIDER
	from finalfinalfile
	GROUP BY PRIMARY_RESPONSIBLE_PROVIDER
	order by SumIndemnityCPI;
QUIT;