CREATION OF A HIERARCHICAL FILE
There were two data files which fed into the combined dataset for TUS, one that included information from the interview and one that contained diary information. These two files were merged into a combined dataset featuring six levels:
- the top level contains household information, including items such as occupation of the household reference person and whether the household has Internet access;
- the second level contains family information (a household can contain multiple families), including items such as the age of the youngest child in the family and whether child care was used;
- the third level contains person information for each person aged 15 years or over in the household/family such as marital status and types of income;
- the fourth level is the "diary day" level, where the diary information begins. Most people have two diary days of information. This level contains items about the quarter of diary collection and the day of the week that the diary day pertains to;
- the fifth level contains the information about diary "episodes" including when the episode started and finished and where the episode took place; and
- the sixth level then breaks each episode into primary and secondary activities (where the person stated they were doing two things at the same time, such as cooking dinner and watching TV). It contains the information about what was happening during each episode (sleeping, eating, working and so on).