Yes, call exececute, merging both datasets together, macro. Plenty of different options. You will however need to provide some test data in the form of a datastep for both input datasets, and show what you want to see at he end.
Catch up on SAS Innovate 2026
Dive into keynotes, announcements and breakthroughs on demand.