Common use of Merging a Person Clause in Contracts

Merging a Person. Level File to the Emergency Room Visit File 1. Create data set PERS by sorting the MEPS 1998 Full Year Population Characteristics File, by the person identifier, DUPERSID. Keep only variables to be merged on to the emergency room visit file and DUPERSID. 2. Create data set EROM by sorting the emergency room visit file by person identifier, DUPERSID. 3. Create final data set NEWEROM by merging these two files by DUPERSID, keeping only records on the emergency room visit file. The following is an example of SAS code which completes these steps: PROC SORT DATA=1998 Full Year Population Characteristics File (KEEP=DUPERSID AGE SEX RACEX) OUT=PERSX; BY DUPERSID; RUN; PROC SORT DATA=EROM; BY DUPERSID; RUN; DATA NEWEROM; MERGE EROM (IN=A) PERSX(IN=B); BY DUPERSID; IF A; RUN;

Merging a Person. Level File to the Emergency Room Visit File 1. ) Create data set PERS by sorting the MEPS 1998 1999 Full Year Population Characteristics File, by the person identifier, DUPERSID. Keep only variables to be merged on to the emergency room visit file and DUPERSID. 2. ) Create data set EROM by sorting the emergency room visit file by person identifier, DUPERSID. 3. ) Create final data set NEWEROM by merging these two files by DUPERSID▇▇▇▇▇▇▇▇, keeping only records on the emergency room visit file. The following is an example of SAS code which completes these steps: PROC SORT DATA=1998 DATA=1999 Full Year Population Characteristics File (KEEP=DUPERSID AGE SEX RACEX) OUT=PERSX; BY DUPERSID; RUN; PROC SORT DATA=EROM; BY DUPERSID; RUN; DATA NEWEROM; MERGE EROM (IN=A) PERSX(IN=B); BY DUPERSID; IF A; RUN;