I have a comma delimited variable length file that I would like to read. The beginning 58 bytes contain fixed data and at byte 59 the comma delimiter begins for the first value. Each variable will contain the zcode(the Z0*** value) and whatever value is associated with the zcode (could be a date, amount code, etc..) The record length can be up to 30,000 bytes. See below for example of input file: ---5----+----6----+----7----+----8----+----9----+----0----+----1----+----2----+- ********************************* Top of Data ********************************* Z00101990244,Z0029...,Z0016-365.000,Z00120.000,Z00130.000,Z00140.000,Z00150.000, Z00102010001,Z0029...,Z00160.000,Z00120.000,Z00130.000,Z00140.000,Z00150.000,Z00 Z00101997248,Z0029...,Z00160.000,Z00120.000,Z00130.000,Z00140.000,Z00150.000,Z00 Z00101999029,Z0029...,Z00160.000,Z00120.000,Z00130.000,Z00140.000,Z00150.000,Z00 Z00101999291,Z0029...,Z00160.000,Z00120.000,Z00130.000,Z00140.000,Z00150.000,Z00 ..... My goal is to create a data set that contains the fixed data and one of the values on a separate line. Below is an example using the first record of the above DSN: Z00101990244 Z0029 ... Z00101990244 Z0016 -365.000 Z00101990244 Z0012 0.000 Z00101990244 Z0013 0.000 Z00101990244 Z0014 0.000 Z00101990244 Z0015 0.000 ...... I have tried using the following code, but I am definitely missing something: DATA DELIM1; INFILE IN1 MISSOVER; FORMAT SRCVAL $80.; INPUT @09 CUST $CHAR12. @25 ACCT13 13. @ ; IF INDEX(_INFILE_,",") > 0 THEN DO; INPUT @ "," SRCVAL @; OUTPUT; END; Any help you can lend to the solution would be greatly appreciated.
... View more