BookmarkSubscribeRSS Feed
Martin_Bryant
Quartz | Level 8

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. 🙂

AhmedAl_Attar
Ammonite | Level 13

Hi @Martin_Bryant 

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

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

Creating Custom Steps in SAS Studio

Check out this tutorial series to learn how to build your own steps in SAS Studio.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 16 replies
  • 4735 views
  • 3 likes
  • 8 in conversation