Date:         Thu, 31 Aug 2000 16:44:20 GMT
Reply-To:     sashole@mediaone.net
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Paul Dorfman <paul_dorfman@HOTMAIL.COM>
Subject:      Re: SAS & PERFORMANCE REPORTER
Comments: To: solmstead@BETASYS.COM
Content-Type: text/plain; format=flowed

Steve,

You did not show how you attempted to read the data. If you have 2
packed-decimal fields to interpret, how come your log says "Invalid data for
T6ESTIME in line 1 486-493" indicating the failure to read a single 8-byte
field? Besides, I have a hunch that the times at hand are stored as IBM PD
time values. One field like that I can clearly discern in your dump by
looking at the first (0) and last (F) nibbles is

2000
001F

which means 20:01:00. You can get 200100 by reading the field using the
plain PD4. However, PDTIME4. informat will get you the real SAS time, i.e.
72060, which you can then format any way thou desirest. If my conjectures
miss the target, sorry; if not, all the better.

Kind regards,
=========================
Paul M. Dorfman
Jacksonville, Fl
=========================


>From: Steve Olmstead <solmstead@BETASYS.COM>
>Reply-To: solmstead@BETASYS.COM
>To: SAS-L@LISTSERV.UGA.EDU
>Subject: SAS & PERFORMANCE REPORTER
>Date: Thu, 31 Aug 2000 10:56:17 -0500
>
>This problem involves SAS not being able to read fields that have a PD4.
>format from CMRDETL de-compressed data using "MainView for CICS
>Performance Reporter". The two fields are CMRTIME and T6ESTIME. Both of
>these fields are 4 byte packed fields. After de-compressing (using
>CMRCMPW) the CMRDETL file I execute SAS and get the following for every
>line of T6ESTIME & CMRTIME data. SAS reads all other fields OK.
>
>NOTE: The infile FILEIN is:
>       Dsname=SYS2.BOOLE.DECOMPRS,
>       Unit=3390,Volume=SSB015,Disp=SHR,Blksize=27998,
>       Lrecl=27994,Recfm=VB
>
>NOTE: Invalid data for T6ESTIME in line 1 486-493.
>2                                                          The SAS System
>
>RULE:
>----+----1----+----2----+----3----+----4----+----5----+----6----+----7
>
>1   CHAR
>CICSP1A1.........i...B.....>FST2CMRFSET9CN10...3...............*......
>     ZONE
>CCCEDFCF20022000B8D60CA85426CEEFCDDCECEFCDFF000F0000000000000005000300
>     NUMR
>393271110083001F490962A089CE62323496253935100003000000000000000C000A03
>
>
>
>Please respond directly by using my e-mail address.
>
>Steve Olmstead
>solmstead@betasys.com

_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at
http://profiles.msn.com.