syntax errors with proc sql

[lmyers2]

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;

[andreas_lds]

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.

[Kurt_Bremser]

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

[Astounding]

The final comma should be a semicolon.

[ed_sas_member]

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;