How do I combine the separate Cross-Section data files together for linked analysis?
There are a number of different reasons why one might want to link files from the Cross-Section together. For instance, users may wish to add data from the Management data file into the Employee Representative data file, in order to compare the responses from managers and employees representatives in the same workplaces. Alternatively, one might wish to add data from the Management data file into the Survey of Employees data file, in order to allow workplace data to be used in the analysis of employee responses. These are both one-to-many matches, and either of these tasks can be achieved using the MATCH FILES command in SPSS or the merge- command in Stata. The two files are combined by matching on the unique workplace identifier (SERNO) which is present on both data files. The diagram below indicates the nature of the matching process, with data from a secondary file (in this case the MQ) being matched onto data from a master file (in this case the SEQ). Master (SEQ) Secondary (MQ) SE
Related Questions
- Can I keep my labs data and analysis reports separate from other data on GeNet, so that other groups can see our data?
- Can I record music or data into separate files in the internal memory or SD card at one setting?
- Can Visual Interactions software analyze data from two separate data sources in one analysis?
