Common use of Choosing PRPL Records for Your Research Question Clause in Contracts

Choosing PRPL Records for Your Research Question. In order to produce estimates from the data in this file, researchers must use the person (or family) level weights released in either of two previously released PUFs, HC-151 or HC-157. Researchers must consult the documentation for these PUFs for guidance on creating nationally representative estimates for different time periods. Note that if there are multiple records per person (DUPERSID) when you merge on weights, you will double count some people, and your estimates will not be nationally representative. There are two solutions: select only one record per person, or aggregate information across PRPL records. How you develop your analytical file depends on your research question. The PRPL file is designed to help answer a wide variety of research questions. AHRQ cannot anticipate all these questions, so this section provides examples of how to use the PRPL file for four research questions. Select the Panel 18 Round 3 and Panel 17 Round 5 records with PRIVCAT>0 and MSUPINSX ne 1 and EVALCOVR=1. Count the number of records for each person (DUPERSID). Create one person-level record for each DUPERSID that has the number of plans (PRPL records). Merge the count variable onto PUF HC-157 and use weights, strata, and PSUs to create nationally representative estimates. Select the Panel 18 Round 3 and Panel 17 Round 5 records with DENTLINS=1 and PRIVCAT in (1, 4, 5) and EVALCOVR=1. Among these records, select one record for each person (DUPERSID). Merge each record onto PUF HC-157 and use weights, strata, and PSUs to create nationally representative estimates. Select the Panel 18 Round 1 and Panel 17 Round 3 records with PRIVCAT in (2, 3, 99) and EVALCOVR=1. Select one record for each policyholder-establishment pair (EPRSIDX). To have a positive weight for the final count, we recommend choosing the covered person record of the policyholder (PHOLDER=1), unless the policyholder is deceased (DECPHLDR=1), in which case then the researcher should choose a different covered person’s record. Merge each record onto PUF HC-151 and use weights, strata, and PSUs to create nationally representative estimates. Select the PRPL records for policyholders of employment-related insurance at the time of the first interview [(Panel 18 Round 1 or Panel 17 Round 3) and PHOLDER=1 and PRIVCAT=1 and EVALCOVR=1]. From the 2013 JOBS file, PUF HC-158, select the records with jobs from which the person retired (SUBTYPE=6 or RETIRJOB=1 or YLEFT=2 or YNOBUSN=2 or WHY_LEFT=3). Persons in Panel 17 may have reported retiring from a job in 2012, so, from the 2012 JOBS file, PUF HC-150, select the records with PANEL=17 and (SUBTYPE=6 or RETIRJOB=1 or YLEFT=2 or YNOBUSN=2 or WHY_LEFT=3). Combine the records from the two JOBS files, keeping only one record per JOBSIDX. Using the JOBSIDX, merge the selected JOBS records onto the selected PRPL records. Select the PRPL records with SUBTYPE=6 or RETIRJOB=1 or YLEFT=2 or YNOBUSN=2 or WHY_LEFT=3 or EMPLSTAT=2. Select one record for each DUPERSID. Merge each record onto PUF HC-157 and use weights, strata, and PSUs to create nationally representative estimates of the number of people with one of these PRPL records.

Choosing PRPL Records for Your Research Question. In order to produce estimates from the data in this file, researchers must use the person (or family) level weights released in either of two previously released PUFs, HC-151 HC-167 or HC-157HC-174. Researchers must consult the documentation for these PUFs for guidance on creating nationally representative estimates for different time periods. Note that if there are multiple records per person (DUPERSID) when you merge on weights, you will double count some people, and your estimates will not be nationally representative. There are two solutions: select only one record per person, or aggregate information across PRPL records. How you develop your analytical file depends on your research question. The PRPL file is designed to help answer a wide variety of research questions. AHRQ cannot anticipate all these questions, so this section provides examples of how to use the PRPL file for four research questions. Select the Panel 18 20 Round 3 and Panel 17 19 Round 5 records with PRIVCAT>0 and MSUPINSX ne 1 and EVALCOVR=1. Count the number of records for each person (DUPERSID). Create one person-level record for each DUPERSID that has the number of plans (PRPL records). Merge the count variable onto PUF HC-157 HC-174 and use weights, strata, and PSUs to create nationally representative estimates. Select the Panel 18 20 Round 3 and Panel 17 19 Round 5 records with DENTLINS=1 and PRIVCAT in (1, 4, 5) and EVALCOVR=1. Among these records, select one record for each person (DUPERSID). Merge each record onto PUF HC-157 HC-174 and use weights, strata, and PSUs to create nationally representative estimates. Select the Panel 18 20 Round 1 and Panel 17 19 Round 3 records with PRIVCAT in (2, 3, 6, 99) and EVALCOVR=1. Select one record for each policyholder-establishment pair (EPRSIDX). To have a positive weight for the final count, we recommend choosing the covered person record of the policyholder (PHOLDER=1), unless the policyholder is deceased (DECPHLDR=1), in which case then the researcher should choose a different covered person’s record. Merge each record onto PUF HC-151 HC-167 and use weights, strata, and PSUs to create nationally representative estimates. Select the PRPL records for policyholders of employment-related insurance at the time of the first interview [(Panel 18 20 Round 1 or Panel 17 19 Round 3) and PHOLDER=1 and PRIVCAT=1 and EVALCOVR=1]. From the 2013 2015 JOBS file, PUF HC-158HC-176, select the records with jobs from which the person retired (SUBTYPE=6 or RETIRJOB=1 or YLEFT=2 or YNOBUSN=2 or WHY_LEFT=3). Persons in Panel 17 19 may have reported retiring from a job in 20122014, so, from the 2012 2014 JOBS file, PUF HC-150HC-166, select the records with PANEL=17 PANEL=19 and (SUBTYPE=6 or RETIRJOB=1 or YLEFT=2 or YNOBUSN=2 or WHY_LEFT=3). Combine the records from the two JOBS files, keeping only one record per JOBSIDX. Using the JOBSIDX, merge the selected JOBS records onto the selected PRPL records. Select the PRPL records with SUBTYPE=6 or RETIRJOB=1 or YLEFT=2 or YNOBUSN=2 or WHY_LEFT=3 or EMPLSTAT=2. Select one record for each DUPERSID. Merge each record onto PUF HC-157 HC-174 and use weights, strata, and PSUs to create nationally representative estimates of the number of people with one of these PRPL records.

Choosing PRPL Records for Your Research Question. In order to produce estimates from the data in this file, researchers must use the person (or family) level weights released in either of two previously released PUFs, HC-151 HC-159 or HC-157HC-165. Researchers must consult the documentation for these PUFs for guidance on creating nationally representative estimates for different time periods. Note that if there are multiple records per person (DUPERSID) when you merge on weights, you will double count some people, and your estimates will not be nationally representative. There are two solutions: select only one record per person, or aggregate information across PRPL records. How you develop your analytical file depends on your research question. The PRPL file is designed to help answer a wide variety of research questions. AHRQ cannot anticipate all these questions, so this section provides examples of how to use the PRPL file for four research questions. Select the Panel 18 19 Round 3 and Panel 17 18 Round 5 records with PRIVCAT>0 and MSUPINSX ne 1 and EVALCOVR=1. Count the number of records for each person (DUPERSID). Create one person-level record for each DUPERSID that has the number of plans (PRPL records). Merge the count variable onto PUF HC-157 HC-165 and use weights, strata, and PSUs to create nationally representative estimates. Select the Panel 18 19 Round 3 and Panel 17 18 Round 5 records with DENTLINS=1 and PRIVCAT in (1, 4, 5) and EVALCOVR=1. Among these records, select one record for each person (DUPERSID). Merge each record onto PUF HC-157 HC-165 and use weights, strata, and PSUs to create nationally representative estimates. Select the Panel 18 19 Round 1 and Panel 17 18 Round 3 records with PRIVCAT in (2, 3, 6, 99) and EVALCOVR=1. Select one record for each policyholder-establishment pair (EPRSIDX). To have a positive weight for the final count, we recommend choosing the covered person record of the policyholder (PHOLDER=1), unless the policyholder is deceased (DECPHLDR=1), in which case then the researcher should choose a different covered person’s record. Merge each record onto PUF HC-151 HC-159 and use weights, strata, and PSUs to create nationally representative estimates. Select the PRPL records for policyholders of employment-related insurance at the time of the first interview [(Panel 18 19 Round 1 or Panel 17 18 Round 3) and PHOLDER=1 and PRIVCAT=1 and EVALCOVR=1]. From the 2013 2014 JOBS file, PUF HC-158HC-166, select the records with jobs from which the person retired (SUBTYPE=6 or RETIRJOB=1 or YLEFT=2 or YNOBUSN=2 or WHY_LEFT=3). Persons in Panel 17 18 may have reported retiring from a job in 20122013, so, from the 2012 2013 JOBS file, PUF HC-150HC-158, select the records with PANEL=17 PANEL=18 and (SUBTYPE=6 or RETIRJOB=1 or YLEFT=2 or YNOBUSN=2 or WHY_LEFT=3). Combine the records from the two JOBS files, keeping only one record per JOBSIDX. Using the JOBSIDX, merge the selected JOBS records onto the selected PRPL records. Select the PRPL records with SUBTYPE=6 or RETIRJOB=1 or YLEFT=2 or YNOBUSN=2 or WHY_LEFT=3 or EMPLSTAT=2. Select one record for each DUPERSID. Merge each record onto PUF HC-157 HC-165 and use weights, strata, and PSUs to create nationally representative estimates of the number of people with one of these PRPL records.

Choosing PRPL Records for Your Research Question. In order to produce estimates from the data in this file, researchers must use the person (or family) level weights released in either of two previously released PUFs, HC-151 HC-177 or HC-157HC-184. Researchers must consult the documentation for these PUFs for guidance on creating nationally representative estimates for different time periods. Note that if there are multiple records per person (DUPERSID) when you merge on weights, you will double count some people, and your estimates will not be nationally representative. There are two solutions: select only one record per person, or aggregate information across PRPL records. How you develop your analytical file depends on your research question. The PRPL file is designed to help answer a wide variety of research questions. AHRQ cannot anticipate all these questions, so this section provides examples of how to use the PRPL file for four research questions. Select the Panel 18 21 Round 3 and Panel 17 20 Round 5 records with PRIVCAT>0 and MSUPINSX ne 1 and EVALCOVR=1. Count the number of records for each person (DUPERSID). Create one person-level record for each DUPERSID that has the number of plans (PRPL records). Merge the count variable onto PUF HC-157 HC-184 and use weights, strata, and PSUs to create nationally representative estimates. Select the Panel 18 21 Round 3 and Panel 17 20 Round 5 records with DENTLINS=1 and PRIVCAT in (1, 4, 5) and EVALCOVR=1. Among these records, select one record for each person (DUPERSID). Merge each record onto PUF HC-157 HC-184 and use weights, strata, and PSUs to create nationally representative estimates. Select the Panel 18 21 Round 1 and Panel 17 20 Round 3 records with PRIVCAT in (2, 3, 6, 99) and EVALCOVR=1. Select one record for each policyholder-establishment pair (EPRSIDX). To have a positive weight for the final count, we recommend choosing the covered person record of the policyholder (PHOLDER=1), unless the policyholder is deceased (DECPHLDR=1), in which case then the researcher should choose a different covered person’s record. Merge each record onto PUF HC-151 HC-177 and use weights, strata, and PSUs to create nationally representative estimates. Select the PRPL records for policyholders of employment-related insurance at the time of the first interview [(Panel 18 21 Round 1 or Panel 17 20 Round 3) and PHOLDER=1 and PRIVCAT=1 and EVALCOVR=1]. From the 2013 2016 JOBS file, PUF HC-158HC-185, select the records with jobs from which the person retired (SUBTYPE=6 or RETIRJOB=1 or YLEFT=2 or YNOBUSN=2 or WHY_LEFT=3). Persons in Panel 17 20 may have reported retiring from a job in 20122015, so, from the 2012 2015 JOBS file, PUF HC-150HC-176, select the records with PANEL=17 PANEL=20 and (SUBTYPE=6 or RETIRJOB=1 or YLEFT=2 or YNOBUSN=2 or WHY_LEFT=3). Combine the records from the two JOBS files, keeping only one record per JOBSIDX. Using the JOBSIDX, merge the selected JOBS records onto the selected PRPL records. Select the PRPL records with SUBTYPE=6 or RETIRJOB=1 or YLEFT=2 or YNOBUSN=2 or WHY_LEFT=3 or EMPLSTAT=2. Select one record for each DUPERSID. Merge each record onto PUF HC-157 HC-184 and use weights, strata, and PSUs to create nationally representative estimates of the number of people with one of these PRPL records.

Choosing PRPL Records for Your Research Question. In order to produce estimates from the data in this file, researchers must use the person (or family) level weights released in either of two previously released PUFs, HC-151 HC-093 or HC-157HC-099. Researchers must consult the documentation for these PUFs for guidance on creating nationally representative estimates for different time periods. Note that if there are multiple records per person (DUPERSID) when you merge on weights, you will double count some people, and your estimates will not be nationally representative. There are two solutions: select only one record per person, or aggregate information across PRPL records. How you develop your analytical file depends on your research question. The PRPL file is designed to help answer a wide variety of research questions. AHRQ cannot anticipate all these questions, so this section provides examples of how to use the PRPL file for four five research questions. Select the Panel 18 11 Round 3 and Panel 17 10 Round 5 records with PRIVCAT>0 and MSUPINSX ne 1 and EVALCOVR=1. Count the number of records for each person (DUPERSID). Create one person-level record for each DUPERSID that has the number of plans (PRPL records). Merge the count variable onto PUF HC-157 HC-099 and use weights, strata, and PSUs to create nationally representative estimates. Select the Panel 18 11 Round 3 and Panel 17 10 Round 5 records with DENTLINS=1 and PRIVCAT in (1, 4, 51,4,5) and EVALCOVR=1. Among these records, select one record for each person (DUPERSID). Merge each record onto PUF HC-157 HC-099 and use weights, strata, and PSUs to create nationally representative estimates. Select the Panel 18 11 Round 1 and Panel 17 10 Round 3 records with PRIVCAT in (2, 3, 99) and EVALCOVR=1. Select one record for each policyholder-establishment pair (EPRSIDX). To have a positive weight for the final count, we recommend choosing the covered person record of the policyholder (PHOLDER=1), unless the policyholder is deceased (DECPHLDR=1), in which case then the researcher should choose a different covered person’s record. Merge each record onto PUF HC-151 HC-093 and use weights, strata, and PSUs to create nationally representative estimates. Select the Panel 11 Round 2 and Panel 10 Round 4 records with SATELIG=1 and RATEPLAN=10. Select one record for each DUPERSID. Merge each record onto PUF HC-099 and use weights, strata, and PSUs to create nationally representative estimates. Select the PRPL records for policyholders of employment-related insurance at the time of the first interview [(Panel 18 11 Round 1 or Panel 17 10 Round 3) and PHOLDER=1 and PRIVCAT=1 and EVALCOVR=1]. From the 2013 2006 JOBS file, PUF HC-158HC-100, select the records with jobs from which the person retired (SUBTYPE=6 or RETIRJOB=1 or YLEFT=2 or YNOBUSN=2 or WHY_LEFT=3). Persons in Panel 17 10 may have reported retiring from a job in 20122005, so, from the 2012 2005 JOBS file, PUF HC-150HC-091, select the records with PANEL=17 PANEL=10 and (SUBTYPE=6 or RETIRJOB=1 or YLEFT=2 or YNOBUSN=2 or WHY_LEFT=3). Combine the records from the two JOBS files, keeping only one record per JOBSIDX. Using the JOBSIDX, merge the selected JOBS records onto the selected PRPL records. Select the PRPL records with SUBTYPE=6 or RETIRJOB=1 RETIREJOB=1 or YLEFT=2 or YNOBUSN=2 or WHY_LEFT=3 or EMPLSTAT=2. Select one record for each DUPERSID. Merge each record onto PUF HC-157 HC-099 and use weights, strata, and PSUs to create nationally representative estimates of the number of people with one of these PRPL records.

Choosing PRPL Records for Your Research Question. In order to produce estimates from the data in this file, researchers must use the person (or family) level weights released in either of two previously released PUFs, HC-151 HC-064 or HC-157HC-073. Researchers must consult the documentation for these PUFs for guidance on creating nationally representative estimates for different time periods. Note that if there are multiple records per person (DUPERSID) when you merge on weights, you will double count some people, and your estimates will not be nationally representative. There are two solutions: select only one record per person, or aggregate information across PRPL records. How you develop your analytical file depends on your research question. The PRPL file is designed to help answer a wide variety of research questions. AHRQ cannot anticipate all these questions, so this section provides examples of how to use the PRPL file for four five research questions. Select the Panel 18 Round 8 round 3 and Panel 17 Round 7 round 5 records with PRIVCAT>0 and MSUPINSX MSUPINS ne 1 and EVALCOVR=1. Count the number of records for each person (DUPERSID). Create one person-person- level record for each DUPERSID that has the number of plans (PRPL records). Merge the count variable onto PUF HC-157 HC-073 and use weights, strata, and PSUs to create nationally representative estimates. Select the Panel 18 Round 8 round 3 and Panel 17 Round 7 round 5 records with DENTLINS=1 DNTLINS=1 and PRIVCAT in (1, 4, 51,4,5) and EVALCOVR=1. Among these records, select one record for each person (DUPERSID). Merge each record onto PUF HC-157 HC-073 and use weights, strata, and PSUs to create nationally representative estimates. Select the Panel 18 Round 8 round 1 and Panel 17 Round 7 round 3 records with PRIVCAT XXXXXXX in (2, 3, 99) and EVALCOVR=1. Select one record for each policyholder-establishment pair (EPRSIDX). To have a positive weight for the final count, we recommend choosing the covered person record of the policyholder (PHOLDER=1), unless the policyholder is deceased (DECPHLDR=1), in which case then the researcher should choose a different covered person’s 's record. Merge each record onto PUF HC-151 HC-064 and use weights, strata, and PSUs to create nationally representative estimates. Select the Panel 8 round 2 and Panel 7 round 4 records with SATELIG=1 and RATEPLAN=10. Select one record for each DUPERSID. Merge each record onto PUF HC-073 and use weights, strata, and PSUs to create nationally representative estimates. Select the PRPL records for policyholders of employment-related insurance at the time of the first interview [(Panel 18 Round 8 round 1 or Panel 17 Round 7 round 3) and PHOLDER=1 and PRIVCAT=1 and EVALCOVR=1]. From the 2013 2003 JOBS file, PUF HC-158HC-074, select the records with for jobs from which the person retired (SUBTYPE=6 or RETIRJOB=1 or YLEFT=2 or YNOBUSN=2 or WHY_LEFT=3). Persons in Panel 17 6 may have reported retiring from a job in 20122001, so, from the 2012 2002 JOBS file, PUF HC-150HC-063, select the records with PANEL=17 PANEL=6 and (SUBTYPE=6 or RETIRJOB=1 or YLEFT=2 or YNOBUSN=2 or WHY_LEFT=3). Combine the records from the two JOBS files, keeping only one record per JOBSIDX. Using the JOBSIDX, merge the selected JOBS records onto the selected PRPL records. Select the PRPL records with SUBTYPE=6 or RETIRJOB=1 RETIREJOB=1 or YLEFT=2 or YNOBUSN=2 or WHY_LEFT=3 or EMPLSTAT=2. Select one record for each DUPERSID. Merge each record onto PUF HC-157 HC-073 and use weights, strata, and PSUs to create nationally representative estimates of the number of people with one of these PRPL records.

Choosing PRPL Records for Your Research Question. In order to produce estimates from the data in this file, researchers must use the person (or family) level weights released in either of two previously released PUFs, HC-151 HC-053 or HC-157HC-062. Researchers must consult the documentation for these PUFs for guidance on creating nationally representative estimates for different time periods. Note that if there are multiple records per person (DUPERSID) when you merge on weights, you will double count some people, and your estimates will not be nationally representative. There are two solutions: select only one record per person, or aggregate information across PRPL records. How you develop your analytical file depends on your research question. The PRPL file is designed to help answer a wide variety of research questions. AHRQ cannot anticipate all these questions, so this section provides examples of how to use the PRPL file for four three research questions. Select the Panel 18 Round 7 round 3 and Panel 17 Round 6 round 5 records with PRIVCAT>0 and MSUPINSX MSUPINS ne 1 and EVALCOVR=1. Count the number of records for each person (DUPERSID). Create one person-person- level record for each DUPERSID that has the number of plans (PRPL records). Merge the count variable onto PUF HC-157 HC-062 and use weights, strata, and PSUs to create nationally representative estimates. Select the Panel 18 Round 7 round 3 and Panel 17 Round 6 round 5 records with DENTLINS=1 DNTLINS=1 and PRIVCAT in (1, 4, 51,4,5) and EVALCOVR=1. Among these records, select one record for each person (DUPERSID). Merge each record onto PUF HC-157 HC-062 and use weights, strata, and PSUs to create nationally representative estimates. Select the Panel 18 Round 7 round 1 and Panel 17 Round 6 round 3 records with PRIVCAT XXXXXXX in (2, 3, 99) and EVALCOVR=1. Select one record for each policyholder-establishment pair (EPRSIDX). To have a positive weight for the final count, we recommend choosing the covered person record of the policyholder (PHOLDER=1), unless the policyholder is deceased (DECPHLDR=1), in which case then the researcher should choose a different covered person’s =s record. Merge each record onto PUF HC-151 HC-053 and use weights, strata, and PSUs to create nationally representative estimates. Select the PRPL records for policyholders of employment-related insurance at the time of the first interview [(Panel 18 Round 1 or Panel 17 Round 3) and PHOLDER=1 and PRIVCAT=1 and EVALCOVR=1]. From the 2013 JOBS file, PUF HC-158, select the records with jobs from which the person retired (SUBTYPE=6 or RETIRJOB=1 or YLEFT=2 or YNOBUSN=2 or WHY_LEFT=3). Persons in Panel 17 may have reported retiring from a job in 2012, so, from the 2012 JOBS file, PUF HC-150, select the records with PANEL=17 and (SUBTYPE=6 or RETIRJOB=1 or YLEFT=2 or YNOBUSN=2 or WHY_LEFT=3). Combine the records from the two JOBS files, keeping only one record per JOBSIDX. Using the JOBSIDX, merge the selected JOBS records onto the selected PRPL records. Select the PRPL records with SUBTYPE=6 or RETIRJOB=1 or YLEFT=2 or YNOBUSN=2 or WHY_LEFT=3 or EMPLSTAT=2. Select one record for each DUPERSID. Merge each record onto PUF HC-157 and use weights, strata, and PSUs to create nationally representative estimates of the number of people with one of these PRPL records.

Choosing PRPL Records for Your Research Question. In order to produce estimates from the data in this file, researchers must use the person (or family) level weights released in either of two previously released PUFs, HC-151 HC-117 or HC-157HC-123. Researchers must consult the documentation for these PUFs for guidance on creating nationally representative estimates for different time periods. Note that if there are multiple records per person (DUPERSID) when you merge on weights, you will double count some people, and your estimates will not be nationally representative. There are two solutions: select only one record per person, or aggregate information across PRPL records. How you develop your analytical file depends on your research question. The PRPL file is designed to help answer a wide variety of research questions. AHRQ cannot anticipate all these questions, so this section provides examples of how to use the PRPL file for four five research questions. Select the Panel 18 14 Round 3 and Panel 17 13 Round 5 records with PRIVCAT>0 and MSUPINSX ne 1 and EVALCOVR=1. Count the number of records for each person (DUPERSID). Create one person-level record for each DUPERSID that has the number of plans (PRPL records). Merge the count variable onto PUF HC-157 HC-123 and use weights, strata, and PSUs to create nationally representative estimates. Select the Panel 18 14 Round 3 and Panel 17 13 Round 5 records with DENTLINS=1 and PRIVCAT in (1, 4, 51,4,5) and EVALCOVR=1. Among these records, select one record for each person (DUPERSID). Merge each record onto PUF HC-157 HC-123 and use weights, strata, and PSUs to create nationally representative estimates. Select the Panel 18 14 Round 1 and Panel 17 13 Round 3 records with PRIVCAT in (2, 3, 99) and EVALCOVR=1. Select one record for each policyholder-establishment pair (EPRSIDX). To have a positive weight for the final count, we recommend choosing the covered person record of the policyholder (PHOLDER=1), unless the policyholder is deceased (DECPHLDR=1), in which case then the researcher should choose a different covered person’s record. Merge each record onto PUF HC-151 HC-117 and use weights, strata, and PSUs to create nationally representative estimates. Select the Panel 14 Round 2 and Panel 13 Round 4 records with SATELIG=1 and RATEPLAN=10. Select one record for each DUPERSID. Merge each record onto PUF HC-123 and use weights, strata, and PSUs to create nationally representative estimates. Select the PRPL records for policyholders of employment-related insurance at the time of the first interview [(Panel 18 14 Round 1 or Panel 17 13 Round 3) and PHOLDER=1 and PRIVCAT=1 and EVALCOVR=1]. From the 2013 2009 JOBS file, PUF HC-158HC-124, select the records with jobs from which the person retired (SUBTYPE=6 or RETIRJOB=1 or YLEFT=2 or YNOBUSN=2 or WHY_LEFT=3). Persons in Panel 17 13 may have reported retiring from a job in 20122008, so, from the 2012 2008 JOBS file, PUF HC-150HC-116, select the records with PANEL=17 PANEL=13 and (SUBTYPE=6 or RETIRJOB=1 or YLEFT=2 or YNOBUSN=2 or WHY_LEFT=3). Combine the records from the two JOBS files, keeping only one record per JOBSIDX. Using the JOBSIDX, merge the selected JOBS records onto the selected PRPL records. Select the PRPL records with SUBTYPE=6 or RETIRJOB=1 RETIREJOB=1 or YLEFT=2 or YNOBUSN=2 or WHY_LEFT=3 or EMPLSTAT=2. Select one record for each DUPERSID. Merge each record onto PUF HC-157 HC-123 and use weights, strata, and PSUs to create nationally representative estimates of the number of people with one of these PRPL records.

Choosing PRPL Records for Your Research Question. In order to produce estimates from the data in this file, researchers must use the person (or family) level weights released in either of two previously released PUFs, HC-151 HC-143 or HC-157HC-149. Researchers must consult the documentation for these PUFs for guidance on creating nationally representative estimates for different time periods. Note that if there are multiple records per person (DUPERSID) when you merge on weights, you will double count some people, and your estimates will not be nationally representative. There are two solutions: select only one record per person, or aggregate information across PRPL records. How you develop your analytical file depends on your research question. The PRPL file is designed to help answer a wide variety of research questions. AHRQ cannot anticipate all these questions, so this section provides examples of how to use the PRPL file for four five research questions. Select the Panel 18 17 Round 3 and Panel 17 16 Round 5 records with PRIVCAT>0 and MSUPINSX ne 1 and EVALCOVR=1. Count the number of records for each person (DUPERSID). Create one person-level record for each DUPERSID that has the number of plans (PRPL records). Merge the count variable onto PUF HC-157 HC-149 and use weights, strata, and PSUs to create nationally representative estimates. Select the Panel 18 17 Round 3 and Panel 17 16 Round 5 records with DENTLINS=1 and PRIVCAT in (1, 4, 5) and EVALCOVR=1. Among these records, select one record for each person (DUPERSID). Merge each record onto PUF HC-157 HC-149 and use weights, strata, and PSUs to create nationally representative estimates. Select the Panel 18 17 Round 1 and Panel 17 16 Round 3 records with PRIVCAT in (2, 3, 99) and EVALCOVR=1. Select one record for each policyholder-establishment pair (EPRSIDX). To have a positive weight for the final count, we recommend choosing the covered person record of the policyholder (PHOLDER=1), unless the policyholder is deceased (DECPHLDR=1), in which case then the researcher should choose a different covered person’s record. Merge each record onto PUF HC-151 HC-143 and use weights, strata, and PSUs to create nationally representative estimates. Select the Panel 17 Round 2 and Panel 16 Round 4 records with SATELIG=1 and RATEPLAN=10. Select one record for each DUPERSID. Merge each record onto PUF HC-149 and use weights, strata, and PSUs to create nationally representative estimates. Select the PRPL records for policyholders of employment-related insurance at the time of the first interview [(Panel 18 17 Round 1 or Panel 17 16 Round 3) and PHOLDER=1 and PRIVCAT=1 and EVALCOVR=1]. From the 2013 2012 JOBS file, PUF HC-158HC-150, select the records with jobs from which the person retired (SUBTYPE=6 or RETIRJOB=1 or YLEFT=2 or YNOBUSN=2 or WHY_LEFT=3). Persons in Panel 17 16 may have reported retiring from a job in 20122011, so, from the 2012 2011 JOBS file, PUF HC-150HC-142, select the records with PANEL=17 PANEL=16 and (SUBTYPE=6 or RETIRJOB=1 or YLEFT=2 or YNOBUSN=2 or WHY_LEFT=3). Combine the records from the two JOBS files, keeping only one record per JOBSIDX. Using the JOBSIDX, merge the selected JOBS records onto the selected PRPL records. Select the PRPL records with SUBTYPE=6 or RETIRJOB=1 or YLEFT=2 or YNOBUSN=2 or WHY_LEFT=3 or EMPLSTAT=2. Select one record for each DUPERSID. Merge each record onto PUF HC-157 HC-149 and use weights, strata, and PSUs to create nationally representative estimates of the number of people with one of these PRPL records.

Choosing PRPL Records for Your Research Question. In order to produce estimates from the data in this file, researchers must use the person (or family) level weights released in either of two previously released PUFs, HC-151 HC-084 or HC-157HC-090. Researchers must consult the documentation for these PUFs for guidance on creating nationally representative estimates for different time periods. Note that if there are multiple records per person (DUPERSID) when you merge on weights, you will double count some people, and your estimates will not be nationally representative. There are two solutions: select only one record per person, or aggregate information across PRPL records. How you develop your analytical file depends on your research question. The PRPL file is designed to help answer a wide variety of research questions. AHRQ cannot anticipate all these questions, so this section provides examples of how to use the PRPL file for four five research questions. Select the Panel 18 10 Round 3 and Panel 17 9 Round 5 records with PRIVCAT>0 and MSUPINSX ne 1 and EVALCOVR=1. Count the number of records for each person (DUPERSID). Create one person-level record for each DUPERSID that has the number of plans (PRPL records). Merge the count variable onto PUF HC-157 HC-090 and use weights, strata, and PSUs to create nationally representative estimates. Select the Panel 18 10 Round 3 and Panel 17 9 Round 5 records with DENTLINS=1 and PRIVCAT in (1, 4, 51,4,5) and EVALCOVR=1. Among these records, select one record for each person (DUPERSID). Merge each record onto PUF HC-157 HC-090 and use weights, strata, and PSUs to create nationally representative estimates. Select the Panel 18 10 Round 1 and Panel 17 9 Round 3 records with PRIVCAT in (2, 3, 99) and EVALCOVR=1. Select one record for each policyholder-establishment pair (EPRSIDX). To have a positive weight for the final count, we recommend choosing the covered person record of the policyholder (PHOLDER=1), unless the policyholder is deceased (DECPHLDR=1), in which case then the researcher should choose a different covered person’s record. Merge each record onto PUF HC-151 HC-084 and use weights, strata, and PSUs to create nationally representative estimates. Select the Panel 10 Round 2 and Panel 9 Round 4 records with SATELIG=1 and RATEPLAN=10. Select one record for each DUPERSID. Merge each record onto PUF HC-090 and use weights, strata, and PSUs to create nationally representative estimates. Select the PRPL records for policyholders of employment-related insurance at the time of the first interview [(Panel 18 10 Round 1 or Panel 17 9 Round 3) and PHOLDER=1 and PRIVCAT=1 and EVALCOVR=1]. From the 2013 2005 JOBS file, PUF HC-158HC-091, select the records with jobs from which the person retired (SUBTYPE=6 or RETIRJOB=1 or YLEFT=2 or YNOBUSN=2 or WHY_LEFT=3). Persons in Panel 17 9 may have reported retiring from a job in 20122004, so, from the 2012 2004 JOBS file, PUF HC-150HC-083, select the records with PANEL=17 PANEL=9 and (SUBTYPE=6 or RETIRJOB=1 or YLEFT=2 or YNOBUSN=2 or WHY_LEFT=3). Combine the records from the two JOBS files, keeping only one record per JOBSIDX. Using the JOBSIDX, merge the selected JOBS records onto the selected PRPL records. Select the PRPL records with SUBTYPE=6 or RETIRJOB=1 RETIREJOB=1 or YLEFT=2 or YNOBUSN=2 or WHY_LEFT=3 or EMPLSTAT=2. Select one record for each DUPERSID. Merge each record onto PUF HC-157 HC-090 and use weights, strata, and PSUs to create nationally representative estimates of the number of people with one of these PRPL records.

Choosing PRPL Records for Your Research Question. In order to produce estimates from the data in this file, researchers must use the person (or family) level weights released in either of two previously released PUFs, HC-151 HC-125 or HC-157HC-132. Researchers must consult the documentation for these PUFs for guidance on creating nationally representative estimates for different time periods. Note that if there are multiple records per person (DUPERSID) when you merge on weights, you will double count some people, and your estimates will not be nationally representative. There are two solutions: select only one record per person, or aggregate information across PRPL records. How you develop your analytical file depends on your research question. The PRPL file is designed to help answer a wide variety of research questions. AHRQ cannot anticipate all these questions, so this section provides examples of how to use the PRPL file for four five research questions. Select the Panel 18 15 Round 3 and Panel 17 14 Round 5 records with PRIVCAT>0 and MSUPINSX ne 1 and EVALCOVR=1. Count the number of records for each person (DUPERSID). Create one person-level record for each DUPERSID that has the number of plans (PRPL records). Merge the count variable onto PUF HC-157 HC-132 and use weights, strata, and PSUs to create nationally representative estimates. Select the Panel 18 15 Round 3 and Panel 17 14 Round 5 records with DENTLINS=1 and PRIVCAT in (1, 4, 51,4,5) and EVALCOVR=1. Among these records, select one record for each person (DUPERSID). Merge each record onto PUF HC-157 HC-132 and use weights, strata, and PSUs to create nationally representative estimates. Select the Panel 18 15 Round 1 and Panel 17 14 Round 3 records with PRIVCAT in (2, 3, 99) and EVALCOVR=1. Select one record for each policyholder-establishment pair (EPRSIDX). To have a positive weight for the final count, we recommend choosing the covered person record of the policyholder (PHOLDER=1), unless the policyholder is deceased (DECPHLDR=1), in which case then the researcher should choose a different covered person’s record. Merge each record onto PUF HC-151 HC-125 and use weights, strata, and PSUs to create nationally representative estimates. Select the Panel 15 Round 2 and Panel 14 Round 4 records with SATELIG=1 and RATEPLAN=10. Select one record for each DUPERSID. Merge each record onto PUF HC-132 and use weights, strata, and PSUs to create nationally representative estimates. Select the PRPL records for policyholders of employment-related insurance at the time of the first interview [(Panel 18 15 Round 1 or Panel 17 14 Round 3) and PHOLDER=1 and PRIVCAT=1 and EVALCOVR=1]. From the 2013 2010 JOBS file, PUF HC-158HC-133, select the records with jobs from which the person retired (SUBTYPE=6 or RETIRJOB=1 or YLEFT=2 or YNOBUSN=2 or WHY_LEFT=3). Persons in Panel 17 14 may have reported retiring from a job in 20122009, so, from the 2012 2009 JOBS file, PUF HC-150HC-124, select the records with PANEL=17 PANEL=14 and (SUBTYPE=6 or RETIRJOB=1 or YLEFT=2 or YNOBUSN=2 or WHY_LEFT=3). Combine the records from the two JOBS files, keeping only one record per JOBSIDX. Using the JOBSIDX, merge the selected JOBS records onto the selected PRPL records. Select the PRPL records with SUBTYPE=6 or RETIRJOB=1 or YLEFT=2 or YNOBUSN=2 or WHY_LEFT=3 or EMPLSTAT=2. Select one record for each DUPERSID. Merge each record onto PUF HC-157 HC-132 and use weights, strata, and PSUs to create nationally representative estimates of the number of people with one of these PRPL records.

Choosing PRPL Records for Your Research Question. In order to produce estimates from the data in this file, researchers must use the person (or family) level weights released in either of two previously released PUFs, HC-151 HC-101 or HC-157HC-107. Researchers must consult the documentation for these PUFs for guidance on creating nationally representative estimates for different time periods. Note that if there are multiple records per person (DUPERSID) when you merge on weights, you will double count some people, and your estimates will not be nationally representative. There are two solutions: select only one record per person, or aggregate information across PRPL records. How you develop your analytical file depends on your research question. The PRPL file is designed to help answer a wide variety of research questions. AHRQ cannot anticipate all these questions, so this section provides examples of how to use the PRPL file for four five research questions. Select the Panel 18 12 Round 3 and Panel 17 11 Round 5 records with PRIVCAT>0 and MSUPINSX ne 1 and EVALCOVR=1. Count the number of records for each person (DUPERSID). Create one person-level record for each DUPERSID that has the number of plans (PRPL records). Merge the count variable onto PUF HC-157 HC-107 and use weights, strata, and PSUs to create nationally representative estimates. Select the Panel 18 12 Round 3 and Panel 17 11 Round 5 records with DENTLINS=1 and PRIVCAT in (1, 4, 51,4,5) and EVALCOVR=1. Among these records, select one record for each person (DUPERSID). Merge each record onto PUF HC-157 HC-107 and use weights, strata, and PSUs to create nationally representative estimates. Select the Panel 18 12 Round 1 and Panel 17 11 Round 3 records with PRIVCAT in (2, 3, 99) and EVALCOVR=1. Select one record for each policyholder-establishment pair (EPRSIDX). To have a positive weight for the final count, we recommend choosing the covered person record of the policyholder (PHOLDER=1), unless the policyholder is deceased (DECPHLDR=1), in which case then the researcher should choose a different covered person’s record. Merge each record onto PUF HC-151 HC-101 and use weights, strata, and PSUs to create nationally representative estimates. Select the Panel 12 Round 2 and Panel 11 Round 4 records with SATELIG=1 and RATEPLAN=10. Select one record for each DUPERSID. Merge each record onto PUF HC-107 and use weights, strata, and PSUs to create nationally representative estimates. Select the PRPL records for policyholders of employment-related insurance at the time of the first interview [(Panel 18 12 Round 1 or Panel 17 11 Round 3) and PHOLDER=1 and PRIVCAT=1 and EVALCOVR=1]. From the 2013 2007 JOBS file, PUF HC-158HC-108, select the records with jobs from which the person retired (SUBTYPE=6 or RETIRJOB=1 or YLEFT=2 or YNOBUSN=2 or WHY_LEFT=3). Persons in Panel 17 11 may have reported retiring from a job in 20122006, so, from the 2012 2006 JOBS file, PUF HC-150HC-100, select the records with PANEL=17 PANEL=11 and (SUBTYPE=6 or RETIRJOB=1 or YLEFT=2 or YNOBUSN=2 or WHY_LEFT=3). Combine the records from the two JOBS files, keeping only one record per JOBSIDX. Using the JOBSIDX, merge the selected JOBS records onto the selected PRPL records. Select the PRPL records with SUBTYPE=6 or RETIRJOB=1 RETIREJOB=1 or YLEFT=2 or YNOBUSN=2 or WHY_LEFT=3 or EMPLSTAT=2. Select one record for each DUPERSID. Merge each record onto PUF HC-157 HC-107 and use weights, strata, and PSUs to create nationally representative estimates of the number of people with one of these PRPL records.

Choosing PRPL Records for Your Research Question. In order to produce estimates from the data in this file, researchers must use the person (or family) level weights released in either of two previously released PUFs, HC-151 HC-034 or HC-157HC-055. Researchers must consult the documentation for these PUFs for guidance on creating nationally representative estimates for different time periods. Note that if there are multiple records per person (DUPERSID) when you merge on weights, you will double count some people, and your estimates will not be nationally representative. There are two solutions: select only one record per person, or aggregate information across PRPL records. How you develop your analytical file depends on your research question. The PRPL file is designed to help answer a wide variety of research questions. AHRQ cannot anticipate all these questions, so this section provides examples of how to use the PRPL file for four three research questions. Select the Panel 18 Round 6 round 3 and Panel 17 Round 5 round 5 records with PRIVCAT>0 and MSUPINSX MSUPINS ne 1 and EVALCOVR=1. Count the number of records for each person (DUPERSID). Create one person-level record for each DUPERSID that has the number of plans (PRPL records). Merge the count variable onto PUF HC-157 HC-055 and use weights, strata, and PSUs to create nationally representative estimates. Select the Panel 18 Round 6 round 3 and Panel 17 Round 5 round 5 records with DENTLINS=1 DNTLINS=1 and PRIVCAT in (1, 4, 51,4,5) and EVALCOVR=1. Among these records, select one record for each person (DUPERSID). Merge each record onto PUF HC-157 HC-055 and use weights, strata, and PSUs to create nationally representative estimates. Select the Panel 18 Round 6 round 1 and Panel 17 Round 5 round 3 records with PRIVCAT XXXXXXX in (2, 3, 99) and EVALCOVR=1. Select one record for each policyholder-establishment pair (EPRSIDX). To have a positive weight for the final count, we recommend choosing the covered person record of the policyholder (PHOLDER=1), unless the policyholder is deceased (DECPHLDR=1), in which case then the researcher should choose a different covered person’s record. Merge each record onto PUF HC-151 HC- 034 and use weights, strata, and PSUs to create nationally representative estimates. Select the PRPL records for policyholders of employment-related insurance at the time of the first interview [(Panel 18 Round 1 or Panel 17 Round 3) and PHOLDER=1 and PRIVCAT=1 and EVALCOVR=1]. From the 2013 JOBS file, PUF HC-158, select the records with jobs from which the person retired (SUBTYPE=6 or RETIRJOB=1 or YLEFT=2 or YNOBUSN=2 or WHY_LEFT=3). Persons in Panel 17 may have reported retiring from a job in 2012, so, from the 2012 JOBS file, PUF HC-150, select the records with PANEL=17 and (SUBTYPE=6 or RETIRJOB=1 or YLEFT=2 or YNOBUSN=2 or WHY_LEFT=3). Combine the records from the two JOBS files, keeping only one record per JOBSIDX. Using the JOBSIDX, merge the selected JOBS records onto the selected PRPL records. Select the PRPL records with SUBTYPE=6 or RETIRJOB=1 or YLEFT=2 or YNOBUSN=2 or WHY_LEFT=3 or EMPLSTAT=2. Select one record for each DUPERSID. Merge each record onto PUF HC-157 and use weights, strata, and PSUs to create nationally representative estimates of the number of people with one of these PRPL records.

Choosing PRPL Records for Your Research Question. In order to produce estimates from the data in this file, researchers must use the person (or family) level weights released in either of two previously released PUFs, HC-151 HC-022 or HC-157HC-039. Researchers must consult the documentation for these PUFs for guidance on creating nationally representative estimates for different time periods. Note that if there are multiple records per person (DUPERSID) when you merge on weights, you will double count some people, and your estimates will not be nationally representative. There are two solutions: select only one record per person, or aggregate information across PRPL records. How you develop your analytical file depends on your research question. The PRPL file is designed to help answer a wide variety of research questions. AHRQ cannot anticipate all these questions, so this section provides examples of how to use the PRPL file for four three research questions. Select the Panel 18 Round 5 round 3 and Panel 17 Round 4 round 5 records with PRIVCAT>0 and MSUPINSX MSUPINS ne 1 and EVALCOVR=1. Count the number of records for each person (DUPERSID). Create one person-person- level record for each DUPERSID that has the number of plans (PRPL records). Merge the count variable onto PUF HC-157 HC-039 and use weights, strata, and PSUs to create nationally representative estimates. Select the Panel 18 Round 5 round 3 and Panel 17 Round 4 round 5 records with DENTLINS=1 DNTLINS=1 and PRIVCAT in (1, 4, 51,4,5) and EVALCOVR=1. Among these records, select one record for each person (DUPERSID). Merge each record onto PUF HC-157 HC-039 and use weights, strata, and PSUs to create nationally representative estimates. Select the Panel 18 Round 5 round 1 and Panel 17 Round 4 round 3 records with PRIVCAT in (2, 3, 99) and EVALCOVR=1. Select one record for each policyholder-establishment pair (EPRSIDX). To have a positive weight for the final count, we recommend choosing the covered person record of the policyholder (PHOLDER=1), unless the policyholder is deceased (DECPHLDR=1), in which case then the researcher should choose a different covered person’s =s record. Merge each record onto PUF HC-151 HC-022 and use weights, strata, and PSUs to create nationally representative estimates. Select the PRPL records for policyholders of employment-related insurance at the time of the first interview [(Panel 18 Round 1 or Panel 17 Round 3) and PHOLDER=1 and PRIVCAT=1 and EVALCOVR=1]. From the 2013 JOBS file, PUF HC-158, select the records with jobs from which the person retired (SUBTYPE=6 or RETIRJOB=1 or YLEFT=2 or YNOBUSN=2 or WHY_LEFT=3). Persons in Panel 17 may have reported retiring from a job in 2012, so, from the 2012 JOBS file, PUF HC-150, select the records with PANEL=17 and (SUBTYPE=6 or RETIRJOB=1 or YLEFT=2 or YNOBUSN=2 or WHY_LEFT=3). Combine the records from the two JOBS files, keeping only one record per JOBSIDX. Using the JOBSIDX, merge the selected JOBS records onto the selected PRPL records. Select the PRPL records with SUBTYPE=6 or RETIRJOB=1 or YLEFT=2 or YNOBUSN=2 or WHY_LEFT=3 or EMPLSTAT=2. Select one record for each DUPERSID. Merge each record onto PUF HC-157 and use weights, strata, and PSUs to create nationally representative estimates of the number of people with one of these PRPL records.

Choosing PRPL Records for Your Research Question. ‌ In order to produce estimates from the data in this file, researchers must use the person (person-level or family) -level weights released in either of two previously released PUFs, HC-151 HC-205 or HC-157HC-212. Researchers must consult the documentation for these PUFs for guidance on creating nationally representative estimates for different time periods. Note that if there are multiple records per person (DUPERSID) when you merge on weights, you will double count some people, and your estimates will not be nationally representative. There are two solutions: select only one record per person, or aggregate information across PRPL records. How you develop your analytical file depends on your research question. The PRPL file is designed to help answer a wide variety of research questions. AHRQ cannot anticipate all these questions, so this section provides examples of how to use the PRPL file for four research questions. Select the Panel 18 24 Round 3 and Panel 17 23 Round 5 records with PRIVCAT>0 PrivateCat>0 and MSUPINSX ne 1 and EVALCOVR=1. Count the number of records for each person (DUPERSID). Create one person-level record for each DUPERSID that has the number of plans (PRPL records). Merge the count variable onto PUF HC-157 HC-212 and use weights, strata, and PSUs to create nationally representative estimates. Select the Panel 18 24 Round 3 and Panel 17 23 Round 5 records with DENTLINS=1 and PRIVCAT PrivateCat in (1, 4, 5) and EVALCOVR=1. Among these records, select one record for each person (DUPERSID). Merge each record onto PUF HC-157 HC-212 and use weights, strata, and PSUs to create nationally representative estimates. Select the Panel 18 24 Round 1 and Panel 17 23 Round 3 records with PRIVCAT PrivateCat in (2, 3, 995, 6) and MSUPINSX ne 1 and EVALCOVR=1. Select one record for each policyholder-establishment pair (EPRSIDX). To have a positive weight for the final count, we recommend choosing the covered person record of the policyholder (PHOLDER=1), unless the policyholder is deceased (DECPHLDR=1), in which case then the researcher should choose a different covered person’s record. Merge each record onto PUF HC-151 HC-205 and use weights, strata, and PSUs to create nationally representative estimates. Select the PRPL records for policyholders of employment-related insurance at the time of the first interview [(Panel 18 24 Round 1 or Panel 17 23 Round 3) and PHOLDER=1 and PRIVCAT=1 PrivateCat =1 and EVALCOVR=1]. From the 2013 2019 JOBS file, PUF HC-158HC-211, using JOBSIDX, select the records with jobs from which the person retired (SUBTYPE=6 or RETIRJOB=1 or YLEFT=2 YNOBUSN_M18=2 or YNOBUSN=2 or WHY_LEFT=3WHY_LEFT_M18=3). Persons in Panel 17 23 may have reported retiring from a job in 20122018, so, from the 2012 2018 JOBS file, PUF HC-150HC-203, using JOBSIDX select the records with PANEL=17 PANEL=23 and (SUBTYPE=6 or RETIRJOB=1 or YLEFT=2 or YNOBUSN=2 or WHY_LEFT=3). Combine the records from the two JOBS files, keeping only one record per JOBSIDX. Using the JOBSIDX, merge the selected JOBS records onto the selected PRPL records. Select the PRPL records with SUBTYPE=6 or RETIRJOB=1 or YLEFT=2 YNOBUSN_M18=2 or YNOBUSN=2 or WHY_LEFT=3 WHY_LEFT_M18=3 or EMPLSTAT=2. Select one record for each DUPERSID. Merge each record onto PUF HC-157 HC-212 and use weights, strata, and PSUs to create nationally representative estimates of the number of people with one of these PRPL records.

Choosing PRPL Records for Your Research Question. In order to produce estimates from the data in this file, researchers must use the person (or family) level weights released in either of two previously released PUFs, HC-151 HC-013 or HC-157HC-038. Researchers must consult the documentation for these PUFs for guidance on creating nationally representative estimates for different time periods. Note that if there are multiple records per person (DUPERSID) when you merge on weights, you will double count some people, and your estimates will not be nationally representative. There are two solutions: select only one record per person, or aggregate information across PRPL records. How you develop your analytical file depends on your research question. The PRPL file is designed to help answer a wide variety of research questions. AHRQ cannot anticipate all these questions, so this section provides examples of how to use the PRPL file for four research questions. Select the Panel 18 Round 4 round 3 and Panel 17 Round 3 round 5 records with PRIVCAT>0 and MSUPINSX MSUPINS ne 1 and EVALCOVR=1. Count the number of records for each person (DUPERSID). Create one person-person- level record for each DUPERSID that has the number of plans (PRPL records). Merge the count variable onto PUF HC-157 HC-038 and use weights, strata, and PSUs to create nationally representative estimates. Select the Panel 18 Round 4 round 3 and Panel 17 Round 3 round 5 records with DENTLINS=1 DNTLINS=1 and PRIVCAT in (1, 4, 51,4,5) and EVALCOVR=1. Among these records, select one record for each person (DUPERSID). Merge each record onto PUF HC-157 HC-038 and use weights, strata, and PSUs to create nationally representative estimates. Select the Panel 18 Round 4 round 1 and Panel 17 Round 3 records with PRIVCAT in (2, 3, 99) and EVALCOVR=1. Select one record for each policyholder-establishment pair (EPRSIDX). To have a positive weight for the final count, we recommend choosing the covered person record of the policyholder (PHOLDER=1), unless the policyholder is deceased (DECPHLDR=1), in which case then the researcher should choose a different covered person’s =s record. Merge each record onto PUF HC-151 HC-013 and use weights, strata, and PSUs to create nationally representative estimates. Select the PRPL records for policyholders of employment-related insurance at the time of the first interview [(Panel 18 Round 1 or Panel 17 Round 3) and PHOLDER=1 and PRIVCAT=1 and EVALCOVR=1]. From the 2013 JOBS file, PUF HC-1581999 Person Round Plan file (HC-047), select all the panel 3 round 1 records with jobs from which the person retired (SUBTYPE=6 or RETIRJOB=1 or YLEFT=2 or YNOBUSN=2 or WHY_LEFT=3). Persons in Panel 17 may have reported retiring from a job in 2012, so, from the 2012 JOBS file, PUF HC-150, select the records with PANEL=17 PRIVCAT>0 and (SUBTYPE=6 or RETIRJOB=1 or YLEFT=2 or YNOBUSN=2 or WHY_LEFT=3). Combine the records from the two JOBS files, keeping only one record per JOBSIDX. Using the JOBSIDX, merge the selected JOBS records onto the selected PRPL recordsMSUPINS ≠ 1 and STATUS1=1. Select the PRPL DUPERSID and EPRSIDX variables. Then select all the round 5 records with SUBTYPE=6 or RETIRJOB=1 or YLEFT=2 or YNOBUSN=2 or WHY_LEFT=3 or EMPLSTAT=2STATUS24=1, and select the EPRSIDX and DUPERSID variables. Select A successful match between round 1 and round 5 records is coverage from the same source in both times. A person might, however, have coverage from more than one record for each DUPERSIDsource in both January and December, so to avoid double counting persons, eliminate any duplicate DUPERSIDs before merging the round 1 and round 5 records. Merge each record the matches onto PUF HC-157 HC-035 and use longitudinal weights, strata, and PSUs to create nationally representative estimates of the number of people with one of these PRPL recordsestimates.