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