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.
Also, please post the complete log of the step by copy/pasting it into a window opened with this button:
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;
Also, please post the complete log of the step by copy/pasting it into a window opened with this button:
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
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.
Ready to level-up your skills? Choose your own adventure.