Common use of Linking Instructions Clause in Contracts

Linking Instructions. ‌ The following steps should be taken to create a file containing persons from any one or more of the twenty years of MEPS HC data. 1. Create a dataset for each year containing the person- and/or event-level records of all persons to be included in the analysis. Keep the unique person identifier (DUPERSID and PANEL), the person-level sampling weight, any classification variables (e.g., sex, race/ethnicity) and response variables (e.g., total expenditure amount, number of prescription drug purchases, etc) to be used in the data analysis. 2. Reconcile the discrepancies in variable names. For all years, most variable names on the annual public use files contain a 2-digit year suffix. For instance, in the 1997 consolidated person-level file (HC-020) the panel variable is called PANEL97, the total annual expenditure amount variable is called TOTEXP97 and the sampling weight variable is called WTDPER97. But in the 2003 dataset (HC-079) these same variables are named PANEL03, TOTEXP03 and PERWT03F, respectively, and in the 1996 dataset (HC-012) the total expenditure and sampling weight variables are named TOTEXP96 and WTDPER96, respectively, and the panel variable is missing (users should assign a value of 1 for each record in HC-012). As illustrated below, the variable names must be made consistent before pooling the data. Note: starting in 2005, the panel variable is called simply PANEL (no year suffix). 1996 (HC-012) 1997 (HC-020) 2003 (HC-079) Combined dataset DUPERSID calculated PANEL WTDPER96 SEX TOTEXP96 DUPERSID PANEL PERWT SEX TOTEXP DUPERSID PANEL97 WTDPER97 SEX TOTEXP97 DUPERSID PANEL PERWT SEX TOTEXP DUPERSID PANEL03 PERWT03F SEX TOTEXP03 DUPERSID PANEL PERWT SEX TOTEXP 3. Create a pooled analysis dataset by combining the individual-year datasets by row; that is, append the records from the 1996 dataset with those from the 1997 and 2003 datasets. 4. Attach the BRR replicate flags to the pooled analysis dataset by column; that is, merge the variables BRR1-BRR128 from this HC-036BRR file to the pooled analysis dataset by DUPERSID and PANEL keeping all records in the pooled analysis dataset and only those records in HC-036BRR dataset that match. Depending on the software being used to manage the datasets, the pooled analysis dataset may need to be sorted by DUPERSID and PANEL prior to merging. 5. To calculate a standard set of 128 BRR replicates, multiply each BRR replicate flag by 2 and by the sample weight (PERWT, if using the example above). That is, BRR1wt = BRR1 * 2 * PERWT and BRR2wt = BRR2 * 2 * PERWT, …, BRR128wt = BRR128 * 2 * PERWT. This method creates a set of balanced replicates whereby half the sample in each replicate will have a replicate weight equal to two times sample weight (if the BRR flag is 1) or 0 (if the BRR flag is 0). Users interested in implementing Xxx’x BRR method may choose different multipliers than 0 and 2 against which to factor the sample weights in each replicate. For instance, they may choose to multiply the sample weights by 0.5 if the BRR flag is 0 and multiply them by 1.5 if the BRR flag is 1.

Linking Instructions. ‌ The following steps should be taken to create a file containing persons from any one or more of the twenty nineteen years of MEPS HC data. 1. Create a dataset for each year containing the person- and/or event-level records of all persons to be included in the analysis. Keep the unique person identifier (DUPERSID and PANEL), the person-level sampling weight, any classification variables (e.g., sex, race/ethnicity) and response variables (e.g., total expenditure amount, number of prescription drug purchases, etc) to be used in the data analysis. 2. Reconcile the discrepancies in variable names. For all years, most variable names on the annual public use files contain a 2-digit year suffix. For instance, in the 1997 consolidated person-level file (HC-020) the panel variable is called PANEL97, the total annual expenditure amount variable is called TOTEXP97 and the sampling weight variable is called WTDPER97. But in the 2003 dataset (HC-079) these same variables are named PANEL03, TOTEXP03 and PERWT03F, respectively, and in the 1996 dataset (HC-012) the total expenditure and sampling weight variables are named TOTEXP96 and WTDPER96, respectively, and the panel variable is missing (users should assign a value of 1 for each record in HC-012). As illustrated below, the variable names must be made consistent before pooling the data. Note: starting in 2005, the panel variable is called simply PANEL (no year suffix). 1996 (HC-012) 1997 (HC-020) 2003 (HC-079) Combined dataset DUPERSID calculated PANEL WTDPER96 SEX TOTEXP96 DUPERSID PANEL PERWT SEX TOTEXP DUPERSID PANEL97 WTDPER97 SEX TOTEXP97 DUPERSID PANEL PERWT SEX TOTEXP DUPERSID PANEL03 PERWT03F SEX TOTEXP03 DUPERSID PANEL PERWT SEX TOTEXP 3. Create a pooled analysis dataset by combining the individual-year datasets by row; that is, append the records from the 1996 dataset with those from the 1997 and 2003 datasets. 4. Attach the BRR replicate flags to the pooled analysis dataset by column; that is, merge the variables BRR1-BRR128 from this HC-036BRR file to the pooled analysis dataset by DUPERSID and PANEL keeping all records in the pooled analysis dataset and only those records in HC-036BRR dataset that match. Depending on the software being used to manage the datasets, the pooled analysis dataset may need to be sorted by DUPERSID and PANEL prior to merging. 5. To calculate a standard set of 128 BRR replicates, multiply each BRR replicate flag by 2 and by the sample weight (PERWT, if using the example above). That is, BRR1wt = BRR1 * 2 * PERWT and BRR2wt = BRR2 * 2 * PERWT, …, BRR128wt = BRR128 * 2 * PERWT. This method creates a set of balanced replicates whereby half the sample in each replicate will have a replicate weight equal to two times sample weight (if the BRR flag is 1) or 0 (if the BRR flag is 0). Users interested in implementing Xxx’x BRR method may choose different multipliers than 0 and 2 against which to factor the sample weights in each replicate. For instance, they may choose to multiply the sample weights by 0.5 if the BRR flag is 0 and multiply them by 1.5 if the BRR flag is 1.

Linking Instructions. ‌ The following steps should be taken to create a file containing persons from any one or more of the twenty twelve years of MEPS HC data. 1. Create a dataset for each year containing the person- and/or event-level records of all persons to be included in the analysis. Keep the unique person identifier (DUPERSID and PANEL), the person-level sampling weight, any classification variables (e.g., sex, race/ethnicity) and response variables (e.g., total expenditure amount, number of prescription drug purchases, etc) to be used in the data analysis. 2. Reconcile the discrepancies in variable names. For all years, most variable names on the annual public use files contain a 2-digit year suffix. For instance, in the 1997 consolidated person-level file (HC-020) the panel variable is called PANEL97, the total annual expenditure amount variable is called TOTEXP97 and the sampling weight variable is called WTDPER97. But in the 2003 dataset (HC-079) these same variables are named PANEL03, TOTEXP03 and PERWT03F, respectively, and in the 1996 dataset (HC-012) the total expenditure and sampling weight variables are named TOTEXP96 and WTDPER96, respectively, and the panel variable is missing (users should assign a value of 1 for each record in HC-012). As illustrated below, the variable names must be made consistent before pooling the data. Note: starting in 2005, the panel variable is called simply PANEL (no year suffix). 1996 (HC-012) 1997 (HC-020) 2003 (HC-079) Combined dataset DUPERSID calculated PANEL WTDPER96 SEX TOTEXP96 DUPERSID PANEL PERWT SEX TOTEXP DUPERSID PANEL97 WTDPER97 SEX TOTEXP97 DUPERSID PANEL03 PERWT03F SEX TOTEXP03 DUPERSID PANEL PERWT SEX TOTEXP DUPERSID PANEL03 PERWT03F PANEL PERWT SEX TOTEXP03 TOTEXP DUPERSID PANEL PERWT SEX TOTEXP 3. Create a pooled analysis dataset by combining the individual-year datasets by row; that is, append the records from the 1996 dataset with those from the 1997 and 2003 datasets. 4. Attach the BRR replicate flags to the pooled analysis dataset by column; that is, merge the variables BRR1-BRR128 from this HC-036BRR file to the pooled analysis dataset by DUPERSID and PANEL keeping all records in the pooled analysis dataset and only those records in HC-036BRR dataset that match. Depending on the software being used to manage the datasets, the pooled analysis dataset may need to be sorted by DUPERSID and PANEL prior to merging. 5. To calculate a standard set of 128 BRR replicates, multiply each BRR replicate flag by 2 and by the sample weight (PERWT, if using the example above). That is, BRR1wt = BRR1 * 2 * PERWT and BRR2wt = BRR2 * 2 * PERWT, …, BRR128wt = BRR128 * 2 * PERWT. This method creates a set of balanced replicates whereby half the sample in each replicate will have a replicate weight equal to two times sample weight (if the BRR flag is 1) or 0 (if the BRR flag is 0). Users interested in implementing Xxx’x BRR method may choose chose different multipliers than 0 and 2 against which to factor the sample weights in each replicate. For instance, they may choose chose to multiply the sample weights by 0.5 if the BRR flag is 0 and multiply them by 1.5 if the BRR flag is 1.

Linking Instructions. ‌ The following steps should be taken to create a file containing persons from any one or more of the twenty years of MEPS HC data. 1. Create a dataset for each year containing the person- and/or event-level records of all persons to be included in the analysis. Keep the unique person identifier (DUPERSID and PANEL), the person-level sampling weight, any classification variables (e.g., sex, race/ethnicity) and response variables (e.g., total expenditure amount, number of prescription drug purchases, etc) to be used in the data analysis. 2. Reconcile the discrepancies in variable names. For all years, most variable names on the annual public use files contain a 2-digit year suffix. For instance, in the 1997 consolidated person-level file (HC-020) the panel variable is called PANEL97, the total annual expenditure amount variable is called TOTEXP97 and the sampling weight variable is called WTDPER97. But in the 2003 dataset (HC-079) these same variables are named PANEL03, TOTEXP03 and PERWT03F, respectively, and in the 1996 dataset (HC-012) the total expenditure and sampling weight variables are named TOTEXP96 and WTDPER96, respectively, and the panel variable is missing (users should assign a value of 1 for each record in HC-012). As illustrated below, the variable names must be made consistent before pooling the data. Note: starting in 2005, the panel variable is called simply PANEL (no year suffix). 1996 (HC-012) 1997 (HC-020) 2003 (HC-079) Combined dataset DUPERSID DUPERSID calculated PANEL PANEL WTDPER96 PERWT SEX SEX TOTEXP96 TOTEXP DUPERSID DUPERSID PANEL97 PANEL WTDPER97 PERWT SEX SEX TOTEXP97 TOTEXP DUPERSID PANEL97 WTDPER97 SEX TOTEXP97 DUPERSID PANEL03 PANEL PERWT03F PERWT SEX TOTEXP DUPERSID PANEL03 PERWT03F SEX TOTEXP03 DUPERSID PANEL PERWT SEX TOTEXP TOTEXP 3. Create a pooled analysis dataset by combining the individual-year datasets by row; that is, append the records from the 1996 dataset with those from the 1997 and 2003 datasets. 4. Attach the BRR replicate flags to the pooled analysis dataset by column; that is, merge the variables BRR1-BRR128 from this HC-036BRR file to the pooled analysis dataset by DUPERSID and PANEL keeping all records in the pooled analysis dataset and only those records in HC-036BRR dataset that match. Depending on the software being used to manage the datasets, the pooled analysis dataset may need to be sorted by DUPERSID and PANEL prior to merging. 5. To calculate a standard set of 128 BRR replicates, multiply each BRR replicate flag by 2 and by the sample weight (PERWT, if using the example above). That is, BRR1wt = BRR1 * 2 * PERWT and BRR2wt = BRR2 * 2 * PERWT, …, BRR128wt = BRR128 * 2 * PERWT. This method creates a set of balanced replicates whereby half the sample in each replicate will have a replicate weight equal to two times sample weight (if the BRR flag is 1) or 0 (if the BRR flag is 0). Users interested in implementing Xxx’x BRR method may choose different multipliers than 0 and 2 against which to factor the sample weights in each replicate. For instance, they may choose to multiply the sample weights by 0.5 if the BRR flag is 0 and multiply them by 1.5 if the BRR flag is 1.

Linking Instructions. ‌ The following steps should be taken to create a file containing persons from any one or more of the twenty years of MEPS HC data. 1. Create a dataset for each year containing the person- and/or event-level records of all persons to be included in the analysis. Keep the unique person identifier (DUPERSID and PANEL), the person-level sampling weight, any classification variables (e.g., sex, race/ethnicity) and response variables (e.g., total expenditure amount, number of prescription drug purchases, etc.) to be used in the data analysis. 2. Reconcile the discrepancies in variable names. For all years, most variable names on the annual public use files contain a 2-digit year suffix. For instance, in the 1997 consolidated person-level file (HC-020) the panel variable is called PANEL97, the total annual expenditure amount variable is called TOTEXP97 and the sampling weight variable is called WTDPER97. But in the 2003 dataset (HC-079) these same variables are named PANEL03, TOTEXP03 and PERWT03F, respectively, and in the 1996 dataset (HC-012) the total expenditure and sampling weight variables are named TOTEXP96 and WTDPER96, respectively, and the panel variable is missing (users should assign a value of 1 for each record in HC-012). As illustrated below, the variable names must be made consistent before pooling the data. Note: starting in 2005, the panel variable is called simply PANEL (no year suffix). 1996 (HC-012) 1997 (HC-020) 2003 (HC-079) Combined dataset DUPERSID calculated PANEL WTDPER96 SEX TOTEXP96 DUPERSID PANEL PERWT SEX TOTEXP DUPERSID DUPERSID PANEL97 PANEL WTDPER97 PERWT SEX SEX TOTEXP97 TOTEXP DUPERSID DUPERSID PANEL03 PANEL PERWT03F PERWT SEX TOTEXP DUPERSID PANEL03 PERWT03F SEX TOTEXP03 DUPERSID PANEL PERWT SEX TOTEXP TOTEXP 3. Create a pooled analysis dataset by combining the individual-year datasets by row; that is, append the records from the 1996 dataset with those from the 1997 and 2003 datasets. 4. Attach the BRR replicate flags to the pooled analysis dataset by column; that is, merge the variables BRR1-BRR128 from this HC-036BRR file to the pooled analysis dataset by DUPERSID and PANEL keeping all records in the pooled analysis dataset and only those records in HC-036BRR dataset that match. Depending on the software being used to manage the datasets, the pooled analysis dataset may need to be sorted by DUPERSID and PANEL prior to merging. 5. To calculate a standard set of 128 BRR replicates, multiply each BRR replicate flag by 2 and by the sample weight (PERWT, if using the example above). That is, BRR1wt = BRR1 * 2 * PERWT and BRR2wt = BRR2 * 2 * PERWT, …, BRR128wt = BRR128 * 2 * PERWT. This method creates a set of balanced replicates whereby half the sample in each replicate will have a replicate weight equal to two times sample weight (if the BRR flag is 1) or 0 (if the BRR flag is 0). Users interested in implementing Xxx’x BRR method may choose different multipliers than 0 and 2 against which to factor the sample weights in each replicate. For instance, they may choose to multiply the sample weights by 0.5 if the BRR flag is 0 and multiply them by 1.5 if the BRR flag is 1.