This isn't a join, as far as I understand SQL notation and syntax. This can be achieved in SQL using a UNION but it requires another pass to get the order correct. But SAS can interleave the records; I was taught the term collate, I digress. The datasets A and B I presume are properly sorted.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.