|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|
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;
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.
Office of Information Technology