topic Re: Getting DISK Full in SAS Programming

Getting DISK Full

KAS25 — Tue, 19 Jan 2021 18:02:22 GMT

ERROR: Insufficient space in file WORK.'SASTMP-000000072'n.UTILITY.

NOTE: File WORK.'SASTMP-000000072'n.UTILITY is damaged. I/O processing did not complete.

WARNING: Limited resources when loading index

Thanks any help or advice would be appreciate

Re: Getting DISK Full

SASKiwi — Tue, 19 Jan 2021 18:58:56 GMT

Please post the code that is causing the issue. Do you use SAS on your PC or connect to a remote SAS server?

Re: Getting DISK Full

KAS25 — Tue, 19 Jan 2021 19:21:24 GMT

Remote server--wondering if the work area where the TEMP space is defined filling up?? or is there something I need to code to make this process work.

Proc SQL;
create Index xeltrans on Pcbsusp.seltrans
(emp_ssn, pp_beg_dt , prcs_pp, txn_pfx_cd, txn_sfx_cd);
INFO: Multiple concurrent threads will be used to create the index.
NOTE: Sort execution failure.
INFO: A single thread will be used to create the index.
ERROR: Insufficient space in file WORK.'SASTMP-000000072'n.UTILITY.
NOTE: File WORK.'SASTMP-000000072'n.UTILITY is damaged. I/O processing did not complete.
WARNING: Limited resources when loading index xeltrans_qtr2 for file PCBSUSP.SELTRANS_QTR2.INDEX

Re: Getting DISK Full

SASKiwi — Tue, 19 Jan 2021 19:34:04 GMT

Talk to your SAS administrator regarding how much WORK space you are using. Normally when you exit your SAS session this space is cleared, but abnormal terminations can leave WORK folders lying around. Usually SAS servers run a regular CLEANWORK process to deal with this. Your administrator will be able to confirm what space you have available.

Creating indexes requires the use of WORK utility files that can get rather large, particularly if indexing large datasets.

Run this to confirm your WORK folder location:

proc datasets library = WORK;
run;
quit;