@Quentin ,
hehehe, call execute inside dosubl, I didn't realised I did it until you pointed it out 😄
About "calling something inside something" - my favour (and kind of revelation too) was Mike Rhoads' macro-function-sandwich concept from: https://support.sas.com/resources/papers/proceedings12/004-2012.pdf
I also agree that dosubl() has a lot more work to do "before" comparing to call execute(), but what I would really like SAS to have would be function like: experssion(), which would accept texstring (containing datastep expression) and would try to evaluate it basing on current datastep values, this would give us possibility to evaluate dynamically created expression.
All the best
Bart
Totally agree @yabwon. I was away from SAS for a couple years so I missed Mike's paper when it first came out. When I read it, I immediately emailed him to tell him that it was amazing, because it allowed a macro programmer to do the impossible. And then he said something like "if you think that's amazing, go read Rick's paper now, because DOSUBL makes it easy to do". And when I read Rick's paper, my head just about exploded for the second time that day.
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!
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.