Joined: 05 Jun 2009 Posts: 185 Location: Planet Earth
I am looking for some help to achieve the following. I have two input files in the following format,
File 1 has two fields. Field 1 will be available from position 1-3 (3 characters long) and field 2 will be available from position 4-13 (10 characters long). This file is presorted in ascending order from position 1-13. For example,
Joined: 09 Mar 2011 Posts: 7310 Location: Inside the Matrix
Yes, unless the number of records on the second file is relatively small, it is a simple JOINKEYS. Use SORTED,NOSEQCK on the second file, but the first will have to be sorted.
You only need matched records, so no JOIN statement. REFORMAT can be very simple, just F1:1,13. Since you are matching from the entire data on F2, then the data matched to on F1 is obviously already the same.