Common use of Linking to the Person-Level File Clause in Contracts

Linking to the Person-Level File. Merging characteristics of interest from the person-level file (e.g., MEPS 2012 Full Year Consolidated File) expands the scope of potential estimates. For example, to estimate the total number of prescribed medicine purchases of persons with specific demographic characteristics (such as age, race, sex, and education), population characteristics from a person-level file need to be merged onto the prescribed medicines file. This procedure is illustrated below. The MEPS 2012 Appendix File, HC-152I, provides additional detail on how to merge MEPS data files. 1. Create data set PERSX by sorting the 2012 Full Year Consolidated File by the person identifier, DUPERSID. Keep only variables to be merged onto the prescribed medicines file and DUPERSID. 2. Create data set PMEDS by sorting the 2012 Prescribed Medicines File by person identifier, DUPERSID. 3. Create final data set NEWPMEDS by merging these two files by DUPERSID, keeping only records on the prescribed medicines file. The following is an example of SAS code, which completes these steps: PROC SORT DATA=IN.HCXXX (KEEP=DUPERSID AGE31X AGE42X AGE53X SEX RACEV1X EDUCYR EDUYRDEG EDRECODE) OUT=PERSX; BY DUPERSID; RUN; PROC SORT DATA=IN.HCXXXA OUT=PMEDS; BY DUPERSID; RUN; DATA NEWPMEDS; MERGE PMEDS (IN=A) PERSX (IN=B); BY DUPERSID; IF A; RUN;

Linking to the Person-Level File. Merging characteristics of interest from the person-level file (e.g., MEPS 2012 2010 Full Year Consolidated File) expands the scope of potential estimates. For example, to estimate the total number of prescribed medicine purchases of persons with specific demographic characteristics (such as age, race, sex, and education), population characteristics from a person-level file need to be merged onto the prescribed medicines file. This procedure is illustrated below. The MEPS 2012 2010 Appendix File, HC-152IHC-135I, provides additional detail on how to merge MEPS data files. 1. Create data set PERSX by sorting the 2012 2010 Full Year Consolidated File by the person identifier, DUPERSID. Keep only variables to be merged onto the prescribed medicines file and DUPERSID. 2. Create data set PMEDS by sorting the 2012 2010 Prescribed Medicines File by person identifier, DUPERSID. 3. Create final data set NEWPMEDS by merging these two files by DUPERSID, keeping only records on the prescribed medicines file. The following is an example of SAS code, which completes these steps: PROC SORT DATA=IN.HCXXX (KEEP=DUPERSID AGE31X AGE42X AGE53X SEX RACEV1X EDUCYR EDUYRDEG EDRECODERACEX EDUCYR) OUT=PERSX; BY DUPERSID; RUN; PROC SORT DATA=IN.HCXXXA OUT=PMEDS; BY DUPERSID; RUN; DATA NEWPMEDS; MERGE PMEDS (IN=A) PERSX (IN=B); BY DUPERSID; ; IF A; RUN;

Linking to the Person-Level File. Merging characteristics of interest from the a person-level file (e.g., MEPS 2012 2016 Full Year Consolidated File) expands the scope of potential estimates. For example, to estimate the total number of prescribed medicine purchases of emergency room visits for persons with specific demographic characteristics (such as e.g., age, race, sex, and education), population characteristics from a person-level file need to be merged onto the prescribed medicines emergency room visit file. This procedure is illustrated below. The MEPS 2012 2016 Appendix File, HC-152IHC-188I, provides additional detail details on how to merge MEPS data files. 1. Create data set dataset PERSX by sorting the 2012 MEPS 2016 Full Year Consolidated File by the person identifier, DUPERSID. Keep only variables to be merged onto the prescribed medicines emergency room visit file and DUPERSID. 2. Create data set PMEDS dataset EROM by sorting the 2012 Prescribed Medicines File emergency room visit file by person identifier, DUPERSID. 3. Create final data set NEWPMEDS dataset NEWEROM by merging these two files by DUPERSID, keeping only records on the prescribed medicines emergency room visit file. The following is an example of SAS code, code which completes these steps: PROC SORT DATA=IN.HCXXX HCXXX (KEEP=DUPERSID AGE31X AGE42X AGE53X SEX RACEV1X EDUCYR EDUYRDEG EDRECODEEDUYRDG HIDEG) OUT=PERSX; BY DUPERSID; RUN; PROC SORT DATA=IN.HCXXXA OUT=PMEDSEROM; BY DUPERSID; RUN; DATA NEWPMEDSNEWEROM; MERGE PMEDS EROM (IN=A) PERSX (IN=B); BY DUPERSID; ; IF A; RUN;

Linking to the Person-Level File. Merging characteristics of interest from the person-level file other MEPS files (e.g., MEPS 2012 Full 2016 Full-Year Consolidated File) expands the scope of potential estimates. For example, to estimate the total number of prescribed medicine purchases of hospital inpatient stays for persons with specific demographic characteristics (such as as, age, race, sex, and education), population characteristics from a person-level file need to be merged onto the prescribed medicines hospital inpatient stays file. This procedure is illustrated below. The MEPS 2012 2016 Appendix File, HC-152IHC-188I, provides additional detail on how to merge MEPS data files. 1. Create data set PERSX by sorting the 2012 MEPS 2016 Full Year Consolidated File by the person identifier, DUPERSID. Keep only variables to be merged onto the prescribed medicines file hospital inpatient stays file, and DUPERSID. 2. Create data set PMEDS STAZ by sorting the 2012 Prescribed Medicines File hospital inpatient stays file by person identifier, DUPERSID. 3. Create final data set NEWPMEDS NEWSTAZ by merging these two files by DUPERSID, keeping only records on the prescribed medicines hospital inpatient stays file. The following is an example of SAS code, code which completes these steps: PROC SORT DATA=IN.HCXXX (KEEPHCXXX(KEEP=DUPERSID AGE31X AGE42X AGE53X SEX RACEV1X EDUCYR EDUYRDEG EDRECODEHIDEG) OUT=PERSX; BY DUPERSID; RUN; PROC SORT DATA=IN.HCXXXA OUT=PMEDSSTAZ; BY DUPERSID; RUN; DATA NEWPMEDSNEWSTAZ; MERGE PMEDS STAZ (IN=A) PERSX (INPERSX(IN=B); BY DUPERSID; ; IF A; RUN;

Linking to the Person-Level File. Merging characteristics of interest from the person-level file other MEPS files (e.g., MEPS 2012 Full 2016 Full-Year Consolidated FileFile or 2016 Prescribed Medicines) expands the scope of potential estimates. For example, to estimate the total number of prescribed medicine purchases of expenditures for medical equipment, visual aids, etc. for persons with specific demographic characteristics (such as age, race, and sex, and education), population characteristics from a person-level file need to be merged onto the prescribed medicines Other Medical Expenses event file. This procedure is illustrated shown below. The MEPS 2012 2016 Appendix File, HC-152IHC-188I, provides additional detail details on how to merge other MEPS data files. 1. Create data set PERSX by sorting the 2012 Full 2016 Full-Year Consolidated File File, by the person identifier, DUPERSID. Keep only variables to be merged onto the prescribed medicines other medical events file and DUPERSID. 2. Create data set PMEDS OMEXP by sorting the 2012 Prescribed Medicines File other medical event file by person identifier, DUPERSID. 3. Create final data set NEWPMEDS NEWOME by merging these two files by DUPERSID, keeping only records on the prescribed medicines other medical event file. The following is an example of SAS code, code which completes these steps: PROC SORT DATA=IN.HCXXX HCXXX (KEEP=DUPERSID AGE31X AGE42X AGE53X SEX RACEV1X EDUCYR EDUYRDEG EDRECODEHIDEG) OUT=PERSX; BY DUPERSID; RUN; PROC SORT DATA=IN.HCXXXA OUT=PMEDSOMEXP; BY DUPERSID; RUN; DATA NEWPMEDSNEWOME; MERGE PMEDS OMEXP (IN=A) PERSX (IN=B); BY DUPERSID; ; IF A; RUN;

Linking to the Person-Level File. Merging characteristics of interest from the person-level file (e.g., MEPS 2012 2015 Full Year Consolidated File) expands the scope of potential estimates. For example, to estimate the total number of prescribed medicine purchases of persons with specific demographic characteristics (such as age, race, sex, and education), population characteristics from a person-level file need to be merged onto the prescribed medicines file. This procedure is illustrated below. The MEPS 2012 2015 Appendix File, HC-152IHC-178I, provides additional detail on how to merge MEPS data files. 1. Create data set PERSX by sorting the 2012 2015 Full Year Consolidated File by the person identifier, DUPERSID. Keep only variables to be merged onto the prescribed medicines file and DUPERSID. 2. Create data set PMEDS by sorting the 2012 2015 Prescribed Medicines File by person identifier, DUPERSID. 3. Create final data set NEWPMEDS by merging these two files by DUPERSID, keeping only records on the prescribed medicines file. The following is an example of SAS code, which completes these steps: PROC SORT DATA=IN.HCXXX (KEEP=DUPERSID AGE31X AGE42X AGE53X SEX RACEV1X EDRECODE EDUYRDG EDUCYR EDUYRDEG EDRECODEHIDEG) OUT=PERSX; BY DUPERSID; RUN; PROC SORT DATA=IN.HCXXXA OUT=PMEDS; BY DUPERSID; RUN; DATA NEWPMEDS; MERGE PMEDS (IN=A) PERSX (IN=B); BY DUPERSID; ; IF A; RUN;

Linking to the Person-Level File. Merging characteristics of interest from the person-level file (e.g., MEPS 2012 2014 Full Year Consolidated File) expands the scope of potential estimates. For example, to estimate the total number of prescribed medicine purchases of persons with specific demographic characteristics (such as age, race, sex, and education), population characteristics from a person-level file need to be merged onto the prescribed medicines file. This procedure is illustrated below. The MEPS 2012 2014 Appendix File, HC-152IHC-168I, provides additional detail on how to merge MEPS data files. 1. Create data set PERSX by sorting the 2012 2014 Full Year Consolidated File by the person identifier, DUPERSID. Keep only variables to be merged onto the prescribed medicines file and DUPERSID. 2. Create data set PMEDS by sorting the 2012 2014 Prescribed Medicines File by person identifier, DUPERSID. 3. Create final data set NEWPMEDS by merging these two files by DUPERSID, keeping only records on the prescribed medicines file. The following is an example of SAS code, which completes these steps: PROC SORT DATA=IN.HCXXX (KEEP=DUPERSID AGE31X AGE42X AGE53X SEX RACEV1X EDUCYR EDUYRDEG EDRECODEEDRECODE EDUYRDG) OUT=PERSX; BY DUPERSID; RUN; PROC SORT DATA=IN.HCXXXA OUT=PMEDS; BY DUPERSID; RUN; DATA NEWPMEDS; MERGE PMEDS (IN=A) PERSX (IN=B); BY DUPERSID; ; IF A; RUN;