What is the best way to call a group of programs and reports repeatedly with a parameter?

[Martin_Bryant]

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]

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