Hello all,
After I runed too many SAS process and lots of memory was used by SAS, SAS performence will be reduced. May I ask how to manually(or automatically) delete/clean old memory occupied by SAS to increase performence of the rest/current SAS job? (PC SAS)
Thanks!
Are you getting messages from the system about memory? If so share the messages.
Otherwise please describe what you are doing and exactly how "performance will be reduced".
You may also have to share some details of your current system options. Can you show the results of this code:
proc options group=memory; run;
Sometimes when posters mention memory, they are really running into something else. For example, perhaps many temporary SAS data sets have been filling the WORK area. Additional processing may write to the WORK area, but has to use disk space that is more fragmented, and thus takes longer to utilize.
If that's actually your situation ... and ... if you can afford to get rid of all the temporary data sets in the WORK area ... here's an easy program to accomplish that:
proc delete data=work._all_;
run;
If you are opening data sets in viewtable or similar and leaving them open then there will be significang memory use as one of the features of Viewtable is that you can EDIT the contents. Which means things have to be kept in memory until viewtable is closed and the result written to disk.
But the question may be 'why' are you opening multiple large data sets?
Create subsets if you are looking for specific types of records. I don't manually scroll through any dataset with maybe more than 1000 records (and very seldom that many) as it is generally an inefficient process and often means that I don't quite know why I am actually looking for in the raw data.
I am often double click table with billions of rows
and thousand columns and try quick browsing from top to end.this must a bad habit.I will try to change it.but any solution can manually release the memory occupied by my SAS? ---------delete some temporary files??
Thanks
Close the view.
When SAS needs the memory it should release it from the cache.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.