Your SAS programs, embedded in web apps and elsewhere

Parallel Processing in SAS Stored Process servers

Reply
Occasional Contributor
Posts: 15

Parallel Processing in SAS Stored Process servers

Hello SAS Experts,

I would like to know if its possible to implement parallel processing in SAS Stored process servers. I know and have implemented the same in SAS Workspace servers but I'm not sure of its feisibility in SAS Stored Process servers.

The said build in which I'm thinking of implementing the same generates Excel outputs in the end and the same is meant to be executed from SAS Information Delivery Portal post its release.

Currently it enforces sequential processing of functionally independent modules one after the other which could be done in parallel to save time, but I'm unsure of its possibility in Stored process servers.

Please cionvey your thoughts.

Regards,

Sarath

Contributor
Posts: 29

Re: Parallel Processing in SAS Stored Process servers

Might I ask how you do this with the Logical Workspace server?

James

Trusted Advisor
Posts: 1,301

Re: Parallel Processing in SAS Stored Process servers

rsubmit

Super User
Posts: 7,782

Re: Parallel Processing in SAS Stored Process servers

When trying this, keep in mind that your HW should be able to to this in a reasonable manner. Starting up the parallel processes will take time and resources, and when those processes compete for resources (CPU cores, RAM, disk access), they may actually slow each other down so that the final result is worse (slower) than simple processing in succession.

A process that runs for 2 minutes and is repeated 10 times takes 20 minutes, but running the 10 processes in parallel may easily take you more than an hour, if your server is not designed for parallel work.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Ask a Question
Discussion stats
  • 3 replies
  • 835 views
  • 0 likes
  • 4 in conversation