Common commands
Commonly-used commands to work with data.
Stata
Data management syntax files
The syntax files below show you how to perform some common data management tasks, e.g., merging two files, matching information of respondent and their partner etc, using Understanding Society data files.
Distributing household level information to the individual level
In this example we will distribute household level information to individuals in those households. We can do this by merging household level file (such as w_hhresp) with an individual level file (such as w_indresp) within the same Wave.
StataRSPSSSAS
Merging individual files across waves into wide format
To match individual level files across two waves into a wide format, do the following (for more waves add wave specific prefix in the foreach statement)
Stata
Summarising individual level information at the household level
In this example we will summarise individual level information within a household (number of 18-24-year-olds in the household) from an individual level file and then add it to the household level file.
StataRSPSSSAS