BookmarkSubscribeRSS Feed
Aexor
Lapis Lazuli | Level 10

Few Question in optimization :-

1. how can we achieve Parallel Processing in SAS.?

2. How can be solve space issue after executing a program in sas 

3. how can we optimize a process involves in reading sas data set ?

 Already tried compress, keep,drop, data _null_ 

4. Latency in SAS.

 

these are few questions i came across, i am looking for any suggestion or documentation which talks about these topics.

 

Thanks!

5 REPLIES 5
Kurt_Bremser
Super User

Enterprise Guide allows the use of parallel SAS sessions within a project. And a lot of SAS procedures support multithreading out of the box, especially SQL

On the storage side, using SPDE libraries can speed up I/O massively.

 

Space issues are dependent on the data you have to use. Some rules of thumb:

  • Reduce data early. Only keep variables and observations that are needed later.
  • Summarize data early, where appropriate.
  • Use compression (selectively).
  • Remove intermediate tables when they are no longer needed.

To optimize a process, the good doctor has to get to know it. So we need to see a code piece that eats lots of time and space to make suggestions for improvement. Also do not forget to add information about the data involved (variable sizes, observation numbers).

 

Define "latency". Latencies are found in network connections, storage, and a gazillion of other things.

Aexor
Lapis Lazuli | Level 10
Thanks much!! It's very helpful
yabwon
Onyx | Level 15

About: "1. how can we achieve Parallel Processing in SAS.?"

If you have XCMD turned-on on your SAS you can check out my little tutorial about running code in parallel in SAS:

https://pages.mini.pw.edu.pl/~jablonskib/SASpublic/Parallel-processing-in-BASE-SAS.sas

 

If you have any questions on that material let me know.

 

All the best

Bart

_______________
Polish SAS Users Group: www.polsug.com and communities.sas.com/polsug

"SAS Packages: the way to share" at SGF2020 Proceedings (the latest version), GitHub Repository, and YouTube Video.
Hands-on-Workshop: "Share your code with SAS Packages"
"My First SAS Package: A How-To" at SGF2021 Proceedings

SAS Ballot Ideas: one: SPF in SAS, two, and three
SAS Documentation



Aexor
Lapis Lazuli | Level 10
Thanks much!
SASKiwi
PROC Star

Parallel processing is also possible using SAS/CONNECT. Refer to the SAS/CONNECT documentation for more details.

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

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

View all other training opportunities.

Discussion stats
  • 5 replies
  • 624 views
  • 6 likes
  • 4 in conversation