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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Submit your idea!
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.