topic Re: Out of space issue in SAS Programming

Out of space issue

gskn — Tue, 16 May 2017 14:54:20 GMT

we are getting below error for PROC REPORT step.

ERROR: Out of space writing to file SYS000XX

I tried to increase work space but failed with same error.

can anyone help with error.

Re: Out of space issue

Kurt_Bremser — Tue, 16 May 2017 15:06:14 GMT

Monitor the work location while the step is running, to see if you actually write data there.

Check if there are quotas for the user running the step that are encountered before the filesystem as such runs out of space

Some systems impose a 2GB limits on filesize as default when a new user is created; less probable reason for your problem IMO, but nevertheless ...

If that does not give you a clue, post the proc report code and some information about the dataset you run it from (involved variables - type and size, number of records)

Re: Out of space issue

ballardw — Tue, 16 May 2017 15:06:56 GMT

How many records do you think you are writing to your output?

Are you sure that you want Proc Report? Report generally means "read by humans" somewhere along the line and running out of space infiles tends to make me think that you may be writting something bigger than most people want to read.

You may want to show the code and messages from the Log. Paste into a code box opened with the Forum {i} icon.

Re: Out of space issue

gskn — Tue, 16 May 2017 15:14:42 GMT

it is PROC REPORT and ODS PDF (writing a report in PDF).

Is there any difference in SAS 9.2 vs SAS 9.4 (with respect to options like STYLE= etc for ODS and options like HEADSKIP, SPACING=1 for proc report).

We recently moved to SAS 9.4.

Re: Out of space issue

Kurt_Bremser — Tue, 16 May 2017 21:21:06 GMT

As already mentioned, some code&log and info about the dataset would be helpful.

Re: Out of space issue

jberkes — Wed, 17 May 2017 13:09:07 GMT

I'm having the same problem and here is my code

DATA   DETAIL;
INFILE DETAIL;
   DROP BEGDATE FUNCDT BILLDTEN;

       INPUT @1 ROLLUP      $5.
              @7 BEGDATE     $10.
             @18 DETAIL      $8.
             @27 FUNC        $4.
             @32 FUNCDT      $10.
             @75 BILLIND     $1.
             @77 BILLDTST    $10.
             @88 BILLDTEN    $10.
             @99 UNITS       14.5
               @99 UNITSX    $CHAR14.
             @115 DESC        $35.
             @150 TYPE        $1.
               ;

IF FUNC ~= 'MB10' THEN DELETE;
RUN;
ODS PDF FILE='PSXXXX.PDF';

PROC REPORT DATA=DETAIL;
RUN;
ODS PDF CLOSE;

the detail is 139,448 rows and the result set is 36,677 rows. Granted, that's too many for a report but I'd like to know if there is solution to the out of space error.

Re: Out of space issue

Kurt_Bremser — Wed, 17 May 2017 13:47:49 GMT

I ran a similar experiment and the result looked like this:

NOTE: The data set WORK.TEST has 58407 observations and 9 variables.
NOTE: DATA statement used (Total process time):
      real time           0.19 seconds
      cpu time            0.06 seconds
      

33         
34         ods pdf file='$HOME/test.pdf';
NOTE: Writing ODS PDF output to DISK destination "/home/XXXX/test.pdf", printer "PDF".
35         proc report data=test;
36         run;

NOTE: There were 58407 observations read from the data set WORK.TEST.
NOTE: The PROCEDURE REPORT printed pages 1-2124.
NOTE: PROZEDUR REPORT used (Total process time):
      real time           1:13.75
      cpu time            38.56 seconds
      

37         ods pdf close;
NOTE: ODS PDF printed 1426 pages to /home/XXXX/test.pdf.

No issues.

Peak usage of WORK throughout the process was ~30 MB.

What operating system(s) are your SAS installations running on?

Re: Out of space issue

jberkes — Wed, 17 May 2017 13:57:08 GMT

MVS SAS 9.4

Z/OS V02R01M00

Since yours worked I'll try a few things with mine to see if I can get it working

Thanks

Jim

Re: Out of space issue

Kurt_Bremser — Wed, 17 May 2017 14:03:39 GMT

OK, that explains the SYS000XX file name. That is a generic temporary file name typical for mainframe operations. It might be that this file is created in a place on z/OS (apart from your WORK) where space is actually very low.

Have a talk with the z/OS operators, so they monitor your SAS job to determine where you are running out of space.

Re: Out of space issue

gskn — Wed, 17 May 2017 14:24:47 GMT

The issue is now resolved.
We added option FILESPPRI and FILESPSEC and it worked.

Re: Out of space issue

jberkes — Wed, 17 May 2017 15:16:46 GMT

FILESPPRI=1000 solved my error

Thanks for the help

Jim