Merging a Person. Level File to the Hospital Inpatient Stays 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 hospital inpatient stays file and DUPERSID.
2. Create data set STAZ by sorting the hospital inpatient stays file by person identifier, DUPERSID.
3. Create final data set NEWSTAZ by merging these two files by DUPERSID, keeping only records on the hospital inpatient stays file. The following is an example of SAS code which completes these steps: PROC SORT DATA=HCXXX(KEEP=DUPERSID AGE SEX EDUC) OUT=PERSX; BY DUPERSID; RUN; PROC SORT DATA=STAYS; BY DUPERSID; RUN; DATA NEWSTAYS; MERGE STAYS (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 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 XXXXXXXX, keeping only records on the emergency room visit file. The following is an example of SAS code which completes these steps: PROC SORT 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;
Merging a Person. Level File to the Emergency Room Visit File
1. Create data set PERS by sorting the MEPS 1997 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=HCXXX(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;
