topic ERROR 22-322: Syntax error, expecting one of the following: a name, *. in SAS Procedures

ERROR 22-322: Syntax error, expecting one of the following: a name, *.

Citrine10 — Thu, 16 Jul 2020 13:46:17 GMT

i keep getting errors when trying to join 2 tables:

ERROR 22-322: Syntax error, expecting one of the following: a name, *.

ERROR 200-322: The symbol is not recognized and will be ignored.

My code:

proc sql;
create table ConsolidatedCust as
(
select *
from customers c, WillWool w
where c.[Cuno] = w.[Cuno]
);
quit;

This is very frustrating. I even tried on top 100 but kept getting the same error. I also tried selecting specific columns but it wouldn't work. Please assist.

Re: ERROR 22-322: Syntax error, expecting one of the following: a name, *.

Citrine10 — Thu, 16 Jul 2020 13:48:15 GMT

I also tried this and i would ideally like to go this route of specifying the join. However i still get the same error:
proc sql;
create table ConsolidatedCust as
select *
from WillWool t
left join customers c
on t.[Cuno] = c.cuno
;quit;

Re: ERROR 22-322: Syntax error, expecting one of the following: a name, *.

Kurt_Bremser — Thu, 16 Jul 2020 13:48:20 GMT

from where do you take the idea of the square brackets?

Try this instead:

proc sql;
create table ConsolidatedCust as
  select *
  from customers c, WillWool w
  where c.Cuno = w.Cuno
;
quit;

Re: ERROR 22-322: Syntax error, expecting one of the following: a name, *.

Kurt_Bremser — Thu, 16 Jul 2020 13:51:15 GMT

Also, please post the complete log of the step by copy/pasting it into a window opened with this button: