I have 2 files of different types of data that I am trying to combine. One file includes information on patient cancer status and the other file includes information on patient demographic and assessment information. The two files both have patient last name and date of service in common (along with a few other variables-but these two are the ones I am trying to combine on), I cannot combine on just patient last name because some patients appear multiple times in the both datasets with different dates of service, so both last name and date of service are needed to identify the specific cases and match the information. My end goal is to have one file that has both the information on patient cancer status and on patient demographic & assessment information in a single file, with each row representing 1 case (and eliminating any patients who don't have a complete set of data from both portions). Is there a way to do this in the data merge steps (and to delete any cases that do not have data available from both data sets)?
... View more