If I need to feed the data from a table that is on the server with the table that I do in SAP's excel after the analysis, can I join it automatically?
Only if the fields on both tables have the same data type and column name
Yes. This is the case. How would I go about this?
You need to provide a lot more detail about what you have and what you are trying to do.
The NATURAL JOIN syntax in PROC SQL will autodetect matching variable names and use those as keys when joining datasets.
proc sql; create table want as select * from a natural join b ; quit;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Register now!
SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.
Find more tutorials on the SAS Users YouTube channel.