Hi,
Many thanks for this. I'll look into Stored Procs as I have never used them in SAS, only SQL. As for the scheduler, we already use that but it has the limitation that we can't use libraries that require a login as the scheduler runs without a client.
Very helpful though. 🙂
if you were to adopt the Stored Process approach suggested by @Sajid01 , which is a good approach, here are few things to be aware of
- Program permissions
- Output permissions
Depending on which execution server (Stored Process Server / Workspace Server) you pick for your Stored Process program, the Read/Write permissions may need to be examined and changed. STP Server would execute the program using the sassrv service account, while Workspace Server would use your userID, as if you are running it interactively via EG.
Hope this helps,
Ahmed
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.