I know I can set some code to run in autoexec.sas when my stored process server starts, but I was wondering if there is a way to set some code to run *every time* a stored process runs. I want to run some code which looks at a userid and allocates a macro library for that person in front of the other standard ones. This needs to run each time a stored process runs, since every stored process might be run by a different person.
I thought there might be a place (somewhere) where I could define a file to run before each stored process? Is there? If there is not a nice way to do it, then I would have to resort to putting a bit of code into every stored process I create (which would be very annoying).