Automatic Join?

[edasdfasdfasdfa]

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?

[ButterflyData]

Only if the fields on both tables have the same data type and column name

[edasdfasdfasdfa]

Yes. This is the case. How would I go about this?

[Tom]

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;