Hi,

Why not use a simple merge for that ?

Sort NCMF by case number;

Sort ACPS by case number;

merge both files...

You did not specified your plaform (MVS, PC, UNIX,...) but this could work on any ...

Remember about K.I.S.S. !

regards, Bernard Tremblay \\\|/// \\ - - // ( @ @ ) +------oOOo-(_)-oOOo----------+---------------------------------+ | Bernard Tremblay | | | La Capitale | Tel: (418) 646-2401 | | | Fax: (418) 646-5960 | | | Int: bernard@capitale.qc.ca | +-----------------------------+---------------------------------+ | Imaginasys enr | Res: (418) 878-4447 | | | Int: bertrem@quebectel.com | +---------------Oooo----------+---------------------------------+ oooO ( ) ( ) ) / \ ( (_/ \_)

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ >>>Date: Fri, 29 May 1998 11:17:55 -0400 >>>Sender: "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU> >>>From: Edward Heaton <edheaton@FENIX2.DOL-ESA.GOV> >>>Subject: SQL help? >>>To: SAS-L@UGA.CC.UGA.EDU >>> >>>Hi; >>> I am stuck. I have two FLAT files: >>> 1. NCMF has about half a million records (600 bytes each) with a unique >>> case number in positions 1-9, and >>> 2. ACPS has about 2 million records (500 bytes each) with the (not unique) >>> case number in positions 2-10. >>>I want to output a flat file with all the records from ACPS whose case number >>>matches any one of the case numbers in NCMF. >>> I think that SQL is my tool; however, I am new to SQL. I want to learn the >>>language (procedure) but am not closed to other methods to accomplish this task. >>>Any help at all is appreciated. >>> >>>***** I sent this earlier, but did not make perfectly clear that the two ***** >>>***** input files are flat files; the responses so far seem to assume that ***** >>>***** NCMF and ACPS are SAS data sets. ***** >>> >>> >>>Edward Heaton, Systems Development Specialist, >>>CDSI Information Technology Solutions Company >>>(A Division of Computer Data Systems, Inc.), >>>on contract at U.S. Department of Labor, Room C-3312, >>>200 Constitution Avenue, Northwest, Washington, DC 20210 >>>(202) 219-5572 edheaton@fenix2.dol-esa.gov >>>