BookmarkSubscribeRSS Feed
Sarath
Calcite | Level 5

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

3 REPLIES 3
Jchapman
Calcite | Level 5

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

James

Kurt_Bremser
Super User

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.

SAS INNOVATE 2024

Innovate_SAS_Blue.png

Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Get the $99 certification deal.jpg

 

 

Back in the Classroom!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 1483 views
  • 0 likes
  • 4 in conversation