The Trips sample

The Trips sample provides an example of database questions with hierarchical data. Unlike the Museum and Short Drinks samples, which are based on real surveys, the Trips sample has been created to demonstrate database questions with hierarchical data. The Trips sample is a small data set that includes a very small number of cases at each level. This is to make it easy to understand what happens when you aggregate the data at the different levels.

The Trips sample comes in the following formats:

▪UNICOM Intelligence Data File. This consists of the UNICOM Intelligence metadata model (MDM) file called trips.mdd and case data in the form of a UNICOM Intelligence Data File called trips.ddf. By default, this data set is installed into the [INSTALL_FOLDER]\IBM\SPSS\DataCollection\7\DDL\Data\Data Collection File\ folder.

The Trips sample represents the data collected using the following fictitious survey:

▪Basic questions. Respondents are first asked a number of personal questions, such as their name, date of birth, country lived in (database question), city lived in (database question), language spoken (database question), and occupation (database question).

▪Trip questions. Respondents are then asked a number of questions regarding recent trips, such as number of trips taken this year, departure dates, number of days away from home, purpose of each trip, countries visited, number of days in each country, cities visited, and a rating for each city.

A loops called Countries is used to ask the days in country, cities visited (database question), and city rating questions (database question), respectively. The loop is iterated (and therefore the questions are asked) as many times as necessary.

Name	Description	Type
Name	Respondent’s name	Text
DOB	Respondent’s date of birth	Date/Time
CountryLiveIn	Respondent’s resident country	Single response database question
Language Spoken	Respondent’s spoken language	Multiple response database question
Occupation	Respondent’s occupation	Single response database question
CityLiveIn	Respondent’s resident city	Single response database question

Name	Description	Type
TripCount	Number of trips taken this year	Numeric
DaysInCountry	Number of days spent in each country	Numeric
CitiesVisited	Cities visited in each country	Multiple response database question
CitiesGrid	Cities in each country	Grid database question
Rating	Rating for each city	Single response