I was given the following scenario. I know it involves a PROC TRANPOSE (or multiple) to get it from long data to wide data, but couldn't get it to work. File1 contains patient identifying number, first name, last name, social security number, date of birth, and sex on 100,000 persons, with one record per patient. File2 contains medical claim information (n=300,000 records) on many but not all of the patients in File1. Each record in File2 includes the patient identifying number, claim date, claim number, up to two diagnosis codes, and up to two procedure codes, with potentially multiple claims per patient. The number of claims per patient is not the same for every patient. You are asked to create File3 from File1 and File2. Link the data in file1 to file2 on patient identifying number, producing file3 that contains one record per patient including patient identifying number, name, DOB, the first claim date, and all diagnosis and procedure codes for all claims for that person.
... View more