topic Automatic Join? in New SAS User

Automatic Join?

edasdfasdfasdfa — Fri, 15 Jan 2021 15:25:02 GMT

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?

Re: Automatic Join?

ButterflyData — Fri, 15 Jan 2021 15:53:32 GMT

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

Re: Automatic Join?

edasdfasdfasdfa — Fri, 15 Jan 2021 16:04:30 GMT

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

Re: Automatic Join?

Tom — Fri, 15 Jan 2021 19:16:13 GMT

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;