If merge is the prefered solution, one suggestion could be to move your data to SPDE, which will sort the input data on the fly using multi-threading. May still use some resources, but would be faster than using sort using indexes at least.
Nearly 200 sessions are now available on demand with the SAS Innovate Digital Pass.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.
Browse our catalog!