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
Nearly 200 sessions are now available on demand with the SAS Innovate Digital Pass.