I'm executing this Job to extract SMF 30_V records:
Code: Select all
//JOBNAME JOB (XXX,TATA),'SMF 30_V',CLASS=J,
// MSGCLASS=X,MSGLEVEL=(1,1),NOTIFY=&SYSUID
//**
//STEP1 EXEC PGM=EQQDELDS
//SAS EXEC MXGSAS
//SMF DD DISP=SHR,DSN=ABCD.SMF.D140217
//OUTFILE DD DSN=OUTPUT.TYP30V.DATA,DISP=(,CATLG),
// LRECL=300,RECFM=VB,SPACE=(CYL,(2,10)),VOL=(,,SER=SMVS02)
//SYSIN DD *
%INCLUDE SOURCLIB(TYPE30);
DATA JOBS2
(KEEP = SYSTEM ACTDLYTM ACTIVETM CPUTM EXCPTOTL JOB PROCSTEP
PROGRAM SERVUNIT SRVCLASS STEPNAME TYPETASK WLMNAME
INITIME INTBTIME INTETIME INTRVLTM CPUUNITS EXCPCOMM EXCPDASD
EXCPERR EXCPTAPE EXCPTODD IOTMCOMM IOTMDASD IOTMERR IOTMOTL
IOUNITS);
SET TYPE30_V;
PROC PRINT DATA=JOBS2;
RUN;
DATA _NULL_;
SET JOBS2;
FILE OUTFILE DLM=',';
PUT SYSTEM ACTDLYTM ACTIVETM CPUTM EXCPTOTL JOB PROCSTEP
PROGRAM SERVUNIT SRVCLASS STEPNAME TYPETASK WLMNAME
INITIME INTBTIME INTETIME INTRVLTM CPUUNITS EXCPCOMM EXCPDASD
EXCPERR EXCPTAPE EXCPTODD IOTMCOMM IOTMDASD IOTMERR IOTMOTL
IOUNITS;
RUN;
Code: Select all
********************************* TOP OF DATA **********************************
1 THE SAS SYSTEM
NOTE: COPYRIGHT (C) 2002-2003 BY SAS INSTITUTE INC., xxx, xx, xxx.
NOTE: SAS (R) 9.1 (xxx)
LICENSED TO xxxxx xxxxxx xxxxxx.
NOTE: THIS SESSION IS EXECUTING ON THE Z/OS V01R12M00 PLATFORM.
NOTE: RUNNING ON IBM MODEL xxxx SERIAL NUMBER xxxxxx.
NOTE: SAS 9.1.3 SERVICE PACK 4
WELCOME TO SAS
SSSSSSSS\ AAAAAAAA\ SSSSSSSS\ 99999999\ 111\
SSSSSSSSSS\ AAAAAAAAAA\ SSSSSSSSSS\ 9999999999\ 11111\
SSS\\\\SSS\ AAA\\\\AAA\ SSS\\\\SSS\ 999\\\\999\ 111111\
SSS\ \\\\ AAA\ AAA\ SSS\ \\\\ 999\ 999\ \\111\\
\SSSSSSSS\ AAAAAAAAAA\ \SSSSSSSS\ \999999999\ 111\
\SSSSSSSS\ AAAAAAAAAA\ \SSSSSSSS\ \99999999\ 111\
\\\\\SSS\ AAA\\\\AAA\ \\\\\SSS\ \\\\\999\ 111\
SSS\ AAA\ AAA\ SSS\ 999\ 111\
SSS\ SSS\ AAA\ AAA\ SSS\ SSS\ 999\ 999\ 111\
SSSSSSSSSS\ AAA\ AAA\ SSSSSSSSSS\ 9999999999\ ...\ 1111111\
SSSSSSSS\ AAAAA\ AAAAA\ SSSSSSSS\ 99999999\ ...\ 1111111\
\\\\\\\\ \\\\\\ \\\\\\ \\\\\\\\ \\\\\\\\ \\\\ \\\\\\\\
NOTE: THE SASUSER LIBRARY WAS NOT SPECIFIED. SASUSER LIBRARY WILL NOW BE THE SAM
NOTE: ALL DATA SETS AND CATALOGS IN THE SASUSER LIBRARY WILL BE DELETED AT THE E
PREVENT THEIR DELETION.
NOTE: SAS SYSTEM OPTIONS SPECIFIED ARE:
SORT=20
NOTE: 1713373184 BYTES WERE AVAILABLE ABOVE THE LINE AT INITIALIZATION.
NOTE: 11509760 BYTES WERE AVAILABLE BELOW THE LINE AT INITIALIZATION.
NOTE: 22044672 BYTES WERE AVAILABLE ABOVE THE LINE AFTER ADJUSTMENT FOR MEMSIZE=
NOTE: THE INITIALIZATION PHASE USED 0.03 CPU SECONDS AND 8349K.
NOTE: THE ADDRESS SPACE HAS USED A MAXIMUM OF 672K BELOW THE LINE AND 8768K ABOV
MXGNOTE: VMXGINIT LAST UPDATED: JAN 6, 2011. CHANGE 28.319.
WELCOME TO MXG SOFTWARE, FROM MERRILL CONSULTANTS, DALLAS, TEXAS
TECH SUPPORT: 214 351 1966 SUPPORT@MXG.COM WWW.MXG.COM
MXG 28.28 DATED JAN 18, 2011 HAS BEEN SUCCESSFULLY INITIALIZED.
FILEREF= SOURCLIB
PHYSICAL NAME= SYS14064.T142822.RA000.USER.NULLPDS.H01
PHYSICAL NAME= NMISA.MXG.SOURCLIB
PHYSICAL NAME= SHARE.MXG.V2828.SOURCLIB
NOTE: THERE WERE 3 OBSERVATIONS READ FROM THE DATA SET SASHELP.VEXTFL.
WHERE UPCASE(FILEREF)='SOURCLIB';
NOTE: THE DATA STATEMENT USED THE FOLLOWING RESOURCES:
4775 SET TYPE30_5 ;
4776 PROC PRINT DATA=JOBS2;
CPU TIME - 00:00:00.00
2 THE SAS SYSTEM
ELAPSED TIME - 00:00:00.07
EXCP COUNT - 76
TASK MEMORY - 3599K (220K DATA, 3379K PROGRAM)
TOTAL MEMORY - 12794K (5536K DATA, 7258K PROGRAM)
NOTE: THE ADDRESS SPACE HAS USED A MAXIMUM OF 672K BELOW THE LINE AND 13244K ABO
1 %INCLUDE SOURCLIB(TYPE30);
180: LINE AND COLUMN CANNOT BE DETERMINED.
180: LINE AND COLUMN CANNOT BE DETERMINED.
180: LINE AND COLUMN CANNOT BE DETERMINED.
NOTE: NOSPOOL IS ON. RERUNNING WITH OPTION SPOOL MAY ALLOW RECOVERY OF THE LINE
ERROR 180-322: STATEMENT IS NOT VALID OR IT IS USED OUT OF PROPER ORDER.
ERROR 180-322: STATEMENT IS NOT VALID OR IT IS USED OUT OF PROPER ORDER.
ERROR 180-322: STATEMENT IS NOT VALID OR IT IS USED OUT OF PROPER ORDER.
4773 DATA JOBS2 (KEEP = JOB JINITIME JTRMTIME JELAPSTM CPUTM
4774 EXCPTOTL IOUNITS SERVUNIT TYPETASK WLMNAME CPUUNITS SRVCLASS);
4777 RUN;
4778 DATA _NULL_;
4779 SET JOBS2;
4780 FILE OUTFILE DLM=',';
ERROR 180-322: STATEMENT IS NOT VALID OR IT IS USED OUT OF PROPER ORDER.
ERROR 180-322: STATEMENT IS NOT VALID OR IT IS USED OUT OF PROPER ORDER.
ERROR 180-322: STATEMENT IS NOT VALID OR IT IS USED OUT OF PROPER ORDER.
4781 PUT JOB JINITIME JTRMTIME JELAPSTM CPUTM
4782 EXCPTOTL IOUNITS SERVUNIT TYPETASK WLMNAME CPUUNITS SRVCLASS;
4783 RUN;
ERROR 180-322: STATEMENT IS NOT VALID OR IT IS USED OUT OF PROPER ORDER.
ERROR 180-322: STATEMENT IS NOT VALID OR IT IS USED OUT OF PROPER ORDER.
ERROR 180-322: STATEMENT IS NOT VALID OR IT IS USED OUT OF PROPER ORDER.
NOTE: THE SAS SYSTEM STOPPED PROCESSING THIS STEP BECAUSE OF ERRORS.
NOTE: SAS SET OPTION OBS=0 AND WILL CONTINUE TO CHECK STATEMENTS. THIS MAY CAUSE
WARNING: THE DATA SET WORK.TYPE30TD MAY BE INCOMPLETE. WHEN THIS STEP WAS STOPP
WARNING: THE DATA SET WORK.TYPE30_D MAY BE INCOMPLETE. WHEN THIS STEP WAS STOPP
WARNING: THE DATA SET WORK.TYPE30_V MAY BE INCOMPLETE. WHEN THIS STEP WAS STOPP
WARNING: THE DATA SET WORK.TYPE30_1 MAY BE INCOMPLETE. WHEN THIS STEP WAS STOPP
WARNING: THE DATA SET WORK.TYPE30_4 MAY BE INCOMPLETE. WHEN THIS STEP WAS STOPP
WARNING: THE DATA SET WORK.TYPE30_5 MAY BE INCOMPLETE. WHEN THIS STEP WAS STOPP
WARNING: THE DATA SET WORK.TYPE30_6 MAY BE INCOMPLETE. WHEN THIS STEP WAS STOPP
WARNING: THE DATA SET WORK.TYPE30MR MAY BE INCOMPLETE. WHEN THIS STEP WAS STOPP
WARNING: THE DATA SET WORK.TYPE30MU MAY BE INCOMPLETE. WHEN THIS STEP WAS STOPP
WARNING: THE DATA SET WORK.TYPE30OM MAY BE INCOMPLETE. WHEN THIS STEP WAS STOPP
NOTE: THE DATA STATEMENT USED THE FOLLOWING RESOURCES:
CPU TIME - 00:00:00.14
ELAPSED TIME - 00:00:00.92
EXCP COUNT - 347
TASK MEMORY - 1392K (1208K DATA, 184K PROGRAM)
TOTAL MEMORY - 15654K (8352K DATA, 7302K PROGRAM)
NOTE: THE ADDRESS SPACE HAS USED A MAXIMUM OF 672K BELOW THE LINE AND 16120K ABO
ERROR: SAS ENDED DUE TO ERRORS.
ERROR: SAS ENDED DUE TO ERRORS.
ERROR: SAS ENDED DUE TO ERRORS.
3 THE SAS SYSTEM
YOU SPECIFIED: OPTIONS ERRORABEND;.
YOU SPECIFIED: OPTIONS ERRORABEND;.
YOU SPECIFIED: OPTIONS ERRORABEND;.
ERROR: ERRORS PRINTED ON PAGES 2,3.
ERROR: ERRORS PRINTED ON PAGES 2,3.
ERROR: ERRORS PRINTED ON PAGES 2,3.
NOTE: THE SAS SESSION USED 0.90 CPU SECONDS AND 15654K.
NOTE: THE ADDRESS SPACE HAS USED A MAXIMUM OF 672K BELOW THE LINE AND 16120K ABO
NOTE: SAS INSTITUTE INC., SAS CAMPUS DRIVE, CARY, NC USA 27513-2414
******************************** BOTTOM OF DATA ********************************