| Date: | Mon, 15 Jun 1998 14:42:52 -0400 |
| Reply-To: | JAMES FELLEY <jfelley@OIT.SI.EDU> |
| Sender: | "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU> |
| From: | JAMES FELLEY <jfelley@OIT.SI.EDU> |
| Subject: | Reading VSAM files |
| Content-Type: | text/plain |
|---|
Dean Duncan asked about reading VSAM files with SAS, and Michael A. Raithell (MICHAEL.RAITHEL@RAITHM49.CUSTOMS.SPRINT.COM) responded that Dean should dump and inspect the records. I agree with Michael. When confused by VSAM records, I dump them and try to make sense of them on paper. I do it in the context of SAS, as follows:
(JCL to identify the NOTFILE file here )
DATA _NULL_ ;
INFILE NOTFILE VSAM SEQ FIRSTOBS = 1 ;
IF _N_ > 10 THEN STOP;
INPUT; LIST;
The raw record (in this case, the first 10 records) is LISTED to the log, with length scales, ASCII/EBDIC representations, and hex representations beneath the ASCII/EBDIC.
People used to IDCAMS dumps find these unreadable, but I like them.
Jim Felley
Email: irmss668@sivm.si.edu
Address:
Office of Information Technology
Smithsonian Institution
Washington DC
|