HINTS Data Merging Code Tool
Use this interactive tool to develop SAS code (version 9.3 or higher) to merge multiple iterations of HINTS data, as well as generate example/template analysis code for frequencies/cross-tabulations and logistic and linear regressions. Stata code is currently in development and will be added to the tool in the future.
Why would you want to merge two or more sets of HINTS data?
Combining multiple iterations of HINTS data can help to fulfill two key goals:
- Examining trends over time. Because of common sampling procedures used across the repeated, cross-sectional HINTS surveys, each HINTS iteration can be considered as an independent sample of the non-institutionalized US adult population 18 and older. Thus, iterations can be merged together to look at patterns over time.
- Yielding a larger sample size. This can be useful specifically when a particular subgroup is of interest (e.g., racial or ethnic subgroups), but there aren’t enough respondents in one HINTS iteration to provide stable outcome estimates. This technique assumes that the outcome of interest does not have significant changes over time and requires that the merged dataset be analyzed as a whole.
A series of videos demonstrating how to merge data from HINTS iterations is available on the HINTS website. Examples of Stata and SPSS codes for merging HINTS data can be found in the Survey Overview & Data Analysis Recommendations file included in the publicly available HINTS data packages.