Being part of a small team that uses Ent. Guide, Stored Processes and Web Report Studio, I am finding that I'm creating macros that replace repetitive code, such as parameter processing, date checking and the like.
My question: How and where can I store these macros, so that I can use them in different stored processes? I currently have to copy and paste macro code, and would much prefer to be able to pull in a stored macro (or two or three...).
You want to store your macro code in an "autocall" location. When you installed the BI Platform you defined an "application server context" -- in our examples, we call it SASMain. Under the SASMain directory where your metadata server (I think) is located, you should find a Lev1 subdirectory with a SASEnvironment subdirectory -- I don't remember the exact path -- you have to look in your Administration guide. Anyway, there's a place in the SASEnvironment subdirectory for your formats catalog, your autocall macros and any SAS code snippets that you are going to %include. (You might get this info more accurately, if you checked with Tech Support.)
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.