topic Re: Bringing In large/multiple files in MVS in SAS Procedures

Bringing In large/multiple files in MVS

deleted_user — Wed, 20 Aug 2008 05:35:32 GMT

Hi All

I am trying to bring in some datasets - about 60 datasets containing invoice information. The problem is when I add any more than 50 datasets, SAS produces a core dump. This is the abend:

+AB400A ===== ABEND-AID =====
REPORT WRITTEN TO: ALLCNTR.ABENDAID.REPORT.SHRDIR
REPORT NUMBER: 441977
JOB-INVL13 STEP-SAS
ABEND CODE=SEC6
followed by

SYSTEM COMPLETION CODE=EC6 REASON CODE=0000FD1D
TIME=21.55.44 SEQ=04452 CPU=0000 ASID=00CE
PSW AT TIME OF ERROR 070C4000 9CC723E4 ILC 0 INTC 00
NO ACTIVE MODULE FOUND - PRIMARY NOT EQUAL TO HOME
NAME=UNKNOWN
DATA AT PSW 1CC723DE - 1F001F11 05EFEBEC D2500096
AR/GR 0: 00000000/00000000_00000000 1: 00000000/00000000_0000000
2: 00000002/00000000_1FD0A5B8 3: 00000000/00000000_8684B13
4: 00000002/00000000_0000007C 5: 00000000/00000000_1FD0A2F
6: 00000000/00000000_1C599130 7: 00000002/00000000_0000010
8: 00000000/00000000_1D221DC0 9: 00000000/00000000_1C59913
A: 00000002/00000000_00FD8ED0 B: 00000000/00000000_00000AC
C: 00000000/00000000_008D40E8 😧 00000000/00000000_00FBB5B
E: 00000002/00000000_9CC723E4 F: 00000000/00000010_00FFCF4

Anyone know any tips on bringing in several files on the mainframe?

Thanks
Shelton.

Re: Bringing In large/multiple files in MVS

deleted_user — Wed, 20 Aug 2008 09:23:24 GMT

SAS abend codes on the mainframe can be somewhat misleading, as they often refer to premature termination of Unix System Services (USS) rather than the actual problem that led to the failure.

If the problem only occurs when a lot of files are open at the same time, then you may have a REGION problem because memory (buffer space) is needed for each and every file open. If you are unable to increase the REGION size, you could try reducing the number of buffers on each dataset e.g. DCB=BUFNO=1 although this will slow down the process. Or you could try splitting the data into two DATA steps and combining the files within SAS itself.

Re: Bringing In large/multiple files in MVS

sbb — Wed, 20 Aug 2008 15:16:26 GMT

This error is due to insufficient CPU time for your job-step. A search of the SAS support website http://support.sas.com/ revealed this condition.

Scott Barry
SBBWorks, Inc.

Re: Bringing In large/multiple files in MVS

deleted_user — Wed, 20 Aug 2008 23:41:30 GMT

Ok thanks all for replying.