Top 10 Ways to Optimize Your SAS Code
Did you miss the Ask the Expert session on Top 10 Ways to Optimize Your SAS Code ? Not to worry, you can catch it on-demand at your leisure.
This session introduces you to ideas and comparisons on ways to Optimize Your SAS Code and describes how you can take advantage of finding a balance of saving space and time within your SAS Environment. We will cover the following:
- Minimizing Reads on INPUT
- KEEP and WHERE Data Set Options
- WHERE clause optimization
- Avoiding Multiple Passes of the Data
- Indexing Considerations
- Sorting
- Avoid Heterogeneous Joins
- Data Set Compression
- SAS Dataset as a Table vs. a View
- Checkpoint/Restarting SAS Jobs
I have added the Q&A from the session below and attached you will find the slides:
In your example of IF THEN .. ELSE IF ...ELSE IF with the states. How does IF THEN ELSE compare to the SELECT (state) statement?
SELECT is simply a different way to handle multiple IF THEN statements. Process times should be similar. If you are working with a production job, it is recommended that you do benchmarking to confirm.
Want more tips? Be sure to subscribe to the Ask the Expert board to receive follow up Q/A, slides and recordings from other SAS Ask the Expert webinars. To subscribe, select Subscribe from the Options drop down button above the articles.
