@monalisa wrote:
Am new to SAS. What i understood till now is SAS merges 2 dataset at a time (not sure though). If this is the case, then here Dataset1 left join dataset2, then output left join dataset3 and so on.Is this correct?
No, I don't think that's accurate.
If you have multiple IDs in each dataset you won't get the results you expect compared to SQL, ie many to many match.
The IF IN statement is what's used to filter the join and create a left join.
Your best bet is to create a sample dataset and compare the results between the two Procs until you get your desired result.
... View more