|
<< Click to Display Table of Contents >> Navigation: User Guide > Data > Handling raw data > Data locations |
For CSV data files the data locations are not important. For these files the question names are used as headers to access the data.
The rest of this section only relates to fixed format data.
Unless you have to lay out the data to match a predetermined data location layout (map) you can select the default of "Program sets" in Project global settings and the program will lay out the data locations for you.
The answers to each question are stored in a particular set of data locations, for example a character question that holds up to 10 letters (including spaces) could be stored in data locations 141-150. There is also an option to store filters in a data location.
TIP: to view the Data locations used, use [Project] [Data locations view] from the Main window.
The raw data for each record (questionnaire) is stored on one line and the data locations are numbered 1, 2, 3, and so on.
The first few data locations on each line are usually reserved for identification purposes, see Raw data structure.
The record length is the last data location used.
Each "card" has 80 or 99 columns.
A data location is a card number followed by a two digit column number:
•101 (card 1, column 1) is the first available data location
•199 (card 1, column 99) is the last available data location on card 1
•99999 (card 999, column 99) is the last available data location
Data locations do not run in a continuous sequence, for example there is no data location 200 because this would be card 2, column 0.
With 80 column cards there are no data locations 181-200 because that would be card 1, columns 81 to 100 and there are only 80 columns per card. 201 is correct because that is card 2, column 1.
The first few data locations on each line (card) are usually reserved for identification purposes, see Raw data structure.
The record length is the number of data locations allocated for each card (80 or 99).
You can choose (in Project global) to use the last 3 digits as column number.
Each "card" has up to 999 columns.
A data location is a card number followed by a three digit column number:
•1001 (card 1, column 1) is the first available data location
•1999 (card 1, column 999) is the last available data location on card 1
•999999 (card 999, column 999) is the last available data location
Data locations do not run in a continuous sequence, for example there is no data location 2000 because this would be card 2, column 0.
The first few data locations on each line (card) are usually reserved for identification purposes, see Raw data structure.
The record length is the number of data locations allocated for each card (up to 999).