topic Re: merging three tables in SAS Programming

merging three tables

HeatherNewton — Tue, 13 Dec 2022 08:44:01 GMT

merge ACCT_NEW_ALL_MAC(IN=A) rate_MAC DEC_ACCT_MAC_OCA_SUM2;
by account_no
if a

Select * from  ACCT_NEW_ALL_MAC A 
left join rate_MAC B on A.account_no=B.account_no
left join DEC_ACCT_MAC_OCA_SUM2 C A.account_no=C.account_no

Hi I am trying to write SAS merging three tables into SQL, please could you review for me and let me know if it make sense?

Thanks.

Re: merging three tables

LinusH — Tue, 13 Dec 2022 08:53:39 GMT

Sure, unless you have other logic in the data step this (almost) the same logic.

But if it's existing code, why change (unless it's to be sent down to a database for processing)?

Re: merging three tables

PeterClemmensen — Tue, 13 Dec 2022 09:06:10 GMT

Hard to say without seeing your entire code, but looks right.

Re: merging three tables

ballardw — Tue, 13 Dec 2022 10:45:19 GMT

How many variables are in common between the data sets other than the By variable(s)?

If there are any then the result of the Merge is almost certainly going to be quit different than that SQL.