Can I PARSE using SAS?

[pmking]

I have an extensive output file <report> that is built on our z/OS using some jcl, and I can with success send this report to my pc as .txt file, but it is ugly.. I tried to export this file into excel, but my end goal is to only grab a few pieces of information from this lengthy report.

Okay, my qeustion is, can I parse for the specific data I need in this report file while it is still on the z/OS using SAS? If so, can you please start me off on the right track? The report looks something like this, the areas in red is all I need:

LOCATION: Test DB2 PERFORMANCE EXPERT (V2) PAGE: 1-1
GROUP: test ACCOUNTING REPORT - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: HP1B TO: NOT SPECIFIED
SUBSYSTEM: test ORDER: PRIMAUTH INTERVAL FROM: 02/15/06 11:55:00.35
DB2 VERSION: test SCOPE: MEMBER TO: 02/15/06 12:54:59.15

PRIMAUTH: test

ELAPSED TIME DISTRIBUTION CLASS 2 TIME DISTRIBUTION
---------------------------------------------------------------- ----------------------------------------------------------------
APPL |=========================================> 82% CPU |=======================================> 79%
DB2 |========> 16% NOTACC |=====> 11%
SUSP |=> 2% SUSP |=====> 10%

AVERAGE APPL(CL.1) DB2 (CL.2) IFI (CL.5) CLASS 3 SUSPENSIONS AVERAGE TIME AV.EVENT HIGHLIGHTS
------------ ---------- ---------- ---------- -------------------- ------------ -------- --------------------------
ELAPSED TIME 0.054207 0.010079 N/P LOCK/LATCH(DB2+IRLM) 0.000149 0.88 #OCCURRENCES : 19982
NONNESTED 0.053791 0.009663 N/A SYNCHRON. I/O 0.000253 0.12 #ALLIEDS : 0
STORED PROC 0.000000 0.000000 N/A DATABASE I/O 0.000084 0.03 #ALLIEDS DISTRIB: 0
UDF 0.000000 0.000000 N/A LOG WRITE I/O 0.000169 0.08 #DBATS : 3684
TRIGGER 0.000416 0.000416 N/A OTHER READ I/O 0.000004 0.00 #DBATS DISTRIB. : 16298
OTHER WRTE I/O 0.000000 0.00 #NO PROGRAM DATA: 0
CPU TIME 0.009384 0.007980 N/P SER.TASK SWTCH 0.000030 0.06 #NORMAL TERMINAT: 19982
AGENT 0.009384 0.007980 N/A UPDATE COMMIT 0.000030 0.06 #ABNORMAL TERMIN: 0
NONNESTED 0.009280 0.007876 N/P OPEN/CLOSE 0.000000 0.00 #CP/X PARALLEL. : 0
STORED PRC 0.000000 0.000000 N/A SYSLGRNG REC 0.000000 0.00 #IO PARALLELISM : 0
UDF 0.000000 0.000000 N/A EXT/DEL/DEF 0.000000 0.00 #INCREMENT. BIND: 0
TRIGGER 0.000104 0.000104 N/A OTHER SERVICE 0.000000 0.00 #COMMITS : 19350
PAR.TASKS 0.000000 0.000000 N/A ARC.LOG(QUIES) 0.000000 0.00 #ROLLBACKS : 1148
ARC.LOG READ 0.000000 0.00 #SVPT REQUESTS : 0
SUSPEND TIME 0.000000 0.001002 N/A DRAIN LOCK 0.000000 0.00 #SVPT RELEASE : 0
AGENT N/A 0.001002 N/A CLAIM RELEASE 0.000000 0.00 #SVPT ROLLBACK : 0
PAR.TASKS N/A 0.000000 N/A PAGE LATCH 0.000000 0.00 MAX SQL CASC LVL: 2
STORED PROC 0.000000 N/A N/A NOTIFY MSGS 0.000000 0.00 UPDATE/COMMIT : 0.40
UDF 0.000000 N/A N/A GLOBAL CONTENTION 0.000567 0.08 SYNCH I/O AVG. : 0.002152
COMMIT PH1 WRITE I/O 0.000000 0.00
NOT ACCOUNT. N/A 0.001097 N/A ASYNCH CF REQUESTS 0.000000 0.00
DB2 ENT/EXIT N/A 23.61 N/A TOTAL CLASS 3 0.001002 1.14
EN/EX-STPROC N/A 0.00 N/A
EN/EX-UDF N/A 0.00 N/A
DCAPT.DESCR. N/A N/A N/P
LOG EXTRACT. N/A N/A N/P

GLOBAL CONTENTION L-LOCKS AVERAGE TIME AV.EVENT GLOBAL CONTENTION P-LOCKS AVERAGE TIME AV.EVENT
------------------------------------- ------------ -------- ------------------------------------- ------------ --------
L-LOCKS 0.000567 0.08 P-LOCKS 0.000000 0.00
PARENT (DB,TS,TAB,PART) 0.000228 0.07 PAGESET/PARTITION 0.000000 0.00

 

[ChrisW75]

You should be able to do this. How much do you know about the INFILE and INPUT statements? I recommend looking at the doco for information on this, it'll help enormously. Once you've done that, if you get stuck, give us a shout here and I'll see what I can do.

 

[pmking]

Where can I get this 'doco' from, I am very new to SAS.

Thanks.

 

[ChrisW75]

Sorry, doco is documentation.

http://support.sas.com/onlinedoc/913/docMainpage.jsp