I think the log is pretty clear?
However, I don't think you want a three level name in your select Clause. Also, you use the alias 'code' for two variables.
Could you please highlight the alias 'code' for me, may I am not sure what are you talking about!
ALWAYS use the {i} button to post logs. ALWAYS.
Your log, correctly posted:
1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 72 73 proc sql; 74 create table work.weston_milling_sas 75 as 76 select intake.name, intake.xlsx.sap code, warehouse.xlsx.sap code _ 22 76
You can see that the pointer points to the second dot in your column name, and that is not valid SQL syntax.
You also have invalid dataset references and aliases containing more than one dot:
from weston_milling_sas.intake.xlsx intake.xlsx
This is also invalid.
I strongly recommend you study the SQL Procedure User's Guide to get a grasp of SQL basics.
PS you have so many catastrophic errors in your code that it is next to impossible to deduct what you are trying to do.
Please supply
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.