Common use of Linking Instructions Clause in Contracts

Linking Instructions. The following steps should be taken to create a file containing persons from the 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). 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 ▇▇▇▇▇▇▇▇ 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 ▇▇▇’▇ 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.

Appears in 1 contract

Sources: Data Use Agreement

Linking Instructions. The following steps should be taken to create a file containing persons from the MEPS HC datapooled analysis dataset. 1. Create a dataset for each year containing the person- and/or event-level records of for all persons to be included in the analysis. Keep the unique person identifier variables (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 However, 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). Starting in 2005, the panel variable is simply named PANEL (no year suffix). 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). 3. Create a pooled analysis dataset by simply combining the individual-year datasets by row; that is(e.g., append the records from the 1996 dataset with those from and 1997 files). In other words, the 1997 and 2003 datasetsnumber of records in the pooled file will equal the sum of the record counts for the individual annual files being pooled. 4. Attach the BRR replicate flags pooled variance structure to the pooled analysis dataset by column; that is, merge merging the variables BRR1-BRR128 STRA9607 and PSU9607 from this HC-036BRR HC-036 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 matchonly. 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 step will add two additional variables to the pooled file (STRA9607 and PSU9607) but have no impact on the number 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 ▇▇▇’▇ 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 1records.

Appears in 1 contract

Sources: Data Use Agreement

Linking Instructions. The following steps should be taken to create a file containing persons from the MEPS HC datapooled analysis dataset. 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). Starting in 2005, the panel variable is simply named PANEL (no year suffix). 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). 3. Create a pooled analysis dataset by simply combining the individual-year datasets by row; that is(e.g., append the records from the 1996 dataset with those from and 1997 files). In other words, the 1997 and 2003 datasetsnumber of records in the pooled file will equal the sum of the record counts for the individual annual files being pooled. 4. Attach the BRR replicate flags pooled variance structure to the pooled analysis dataset by column; that is, merge merging the variables BRR1-BRR128 STRA9618 and PSU9618 from this HC-036BRR HC-036 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 matchonly. 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 step will add two additional variables to the pooled file (STRA9618 and PSU9618) but have no impact on the number 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 ▇▇▇’▇ 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 1records.

Appears in 1 contract

Sources: Data Use Agreement