BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Citrine10
Obsidian | Level 7

hi 

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.

1 ACCEPTED SOLUTION
3 REPLIES 3
Citrine10
Obsidian | Level 7
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;
Kurt_Bremser
Super User

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;

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 1053 views
  • 0 likes
  • 2 in conversation