Hi SAS Expert Team,
I have a query reading the large VB file in Mainframes. File specs are below.
File length = 11504
File Type = VB (Variable block)
Contains Records with variable length. Example : If record 1 have the length of 765, then the rest of the characters in the observation 1 are null values. At position, 766 there will be CRLF that will specify the end of the observation.
All the obseravations start with the date in the format 'YYYYMMDD' format.
Many instances, thre is a need to filter data on basis of
> DATE in the first 8 characters and
> customer-id placed randomly in the observation
> Invoice Number placed at the fixed position of 65.
How should I write a DATA step to read a Mainframe VB file and create sub-file based on the criteria.
Regards,
Kumar.
... View more