Hi...I'm also dealing with the same questions..
So I'll post to ussufull approaches:
1) In SAS/STAT, use data statement: https://www.lexjansen.com/wuss/2004/posters/c_post_the_sas_calculations_.pdf
2) In SAS/ETS, use PROC EXPAND https://support.sas.com/kb/24/990.html
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Register Now
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!