I can do this inner join but how can I achieve same out which sas merge produces . Actually bigger picture is I am converting SAS code to SPARK 3 I do not have merge in spark only i have joins, if you can replicate SAS merge output into sql , it will be helpful for me.
... View more