I have a key file (File #2) , with a field that is also on file #1. Using Merge I want to create a 3rd file of records from File #1 that share a key field matching records in File #2. File #1 has multiple records with the key from one record in File #2, but only the first record is put into File #3. I want all occurrences from File #2 that match File #1 in File #3. How do I do that? DATA ORDSSEL; MERGE PROD(IN = INONE) KEYFILE(IN = INTWO) ; BY VIN; IF INONE AND INTWO THEN DO; FILE THAIPROD; PUT @1 ALL1 $CHAR11. @12 VIN $CHAR17. @29 ALL2 $CHAR49. @78 TYPE $CHAR3.; END;
... View more