BookmarkSubscribeRSS Feed
deleted_user
Not applicable
I have problem about the space in hardisk for sas temp files, I have to run data around 1.5 million lines every month, when sas is processing, sas must create temp file and it takes much time and space in harddisk and caused reduce the performance of processing, sometimes it shows the messeage that
"out of resource" press R to retry .....
How can i solve this problem for example ?
is it impossible to delete temp file during sas is running ? I means delete it manually by myself, I'm afraid that if i delete it, it will interupt the process.
is it impossible to use some option to tell sas not create temp files during running or after finish each process, delete it ?
or whatever.

thanks in advance.
4 REPLIES 4
Doc_Duke
Rhodochrosite | Level 12
Manually deleting work datasets while SAS is still processing is a dangerous efficiency.

You may want to look at some of the BBU. "Professional SAS Programming Secrets" comes to mind as useful here. You could also search support.sas.com under "efficiency" or "disk space".

Some initial ideas that effect the SAS temp file storage:
--You could add PROC DATASETS in your job stream to delete datasets you no longer need.
--If you are running out of space during sorts, you could change the sort parameters to do a TAGSORT.
--You could point your work directory to a disk drive with more disk space, hardware is cheap these days and adding a local disk drive may be better than using a network drive (this is changed in sasv8.cfg or sasv9.cfg).
--You could create datasets as VIEWs instead of work files.
--Judicious use of KEEP and DELETE can save lots of space.
--LENGTH statements are important in large datasets.

Except for the new disk drive, these solutions are going to require that you spend some 'quality time' examining and revising your code.
darrylovia
Quartz | Level 8
You compress try to compress the datasets

options compress=binary;

That may reduce the size of you data set
Doc_Duke
Rhodochrosite | Level 12
In addtion to darryliova's comment, if you are using Windows NTFS or Solaris 10, you almost an 80% reduction in disk space usage by using the OS compression. SAS's compression and the OS compression are not additive; you don't make any gains by adding the SAS option to the OS compression.
deleted_user
Not applicable
You could use %squeeze macro to reduce the size (down to half) of your data. Useful one and you can download from SAS/Tech...

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

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
  • 4 replies
  • 581 views
  • 0 likes
  • 3 in conversation