05-04-2017 12:57 PM - edited 05-04-2017 12:58 PM
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)
05-04-2017 01:01 PM
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;
05-04-2017 01:25 PM
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_;
05-04-2017 03:12 PM
05-04-2017 04:17 PM
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.
05-04-2017 05:11 PM - edited 05-04-2017 05:12 PM
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??
05-04-2017 11:29 PM