2.6.6.1 Syntax for VALUE LABELS
VALUE LABELS
VARNAME1
RESPONSE_OPTIONS_VALUE[0] “RESPONSE_OPTIONS_TEXT[0]”
RESPONSE_VALUES[1] “RESPONSE_OPTIONS_TEXT[1]”
RESPONSE_VALUES[2] “RESPONSE_OPTIONS_TEXT[2]” /
VARNAME2
RESPONSE_OPTIONS_VALUE[0] RESPONSE_OPTIONS_TEXT[0]
RESPONSE_VALUES[1] RESPONSE_OPTIONS_TEXT[1]
RESPONSE_VALUES[2] RESPONSE_OPTIONS_TEXT[2] /
2.6.6.2 SPSS Data Definitions for Built-in System Fields
Subject Attribute: Date of Birth
SPSS Data Definition Property | Value | Encoding |
Name | DateofBirth | DateofBirth |
Type | Date | ADATE10 |
Width | N/A |
|
Decimals | N/A |
|
Label | Date of Birth | Date of Birth |
Values | None |
|
Missing | None |
|
Columns | 10 |
|
Align | Right |
|
Measure | Unknown |
|
Subject Attribute: Sex
SPSS Data Definition Property | Value | Encoding |
Name | Sex | Sex |
Type | String | A |
Width | 1 | 1 |
Decimals | N/A |
|
Label | Date of Birth | Date of Birth |
Values | M, F | Sex |
Missing | None |
|
Columns | 1 |
|
Align | Left |
|
Measure | Unknown |
|
Subject Attribute: Subject Status
SPSS Data Definition Property | Value | Encoding |
Name | SubjectStatus | SubjectStatus |
Type | String | A |
Width | [maximum length of subject status string across all the subjects] | [maximum length of subject status string across all the subjects] |
Decimals | N/A |
|
Label | Subject Status | Subject Status |
Values | None |
|
Missing | None |
|
Columns | [maximum length of subject status string across all the subjects] | [maximum length of subject status string across all the subjects] |
Align | Left |
|
Measure | Unknown |
|
Subject Attribute: Person ID
SPSS Data Definition Property | Value | Encoding |
Name | PersonID | PersonID |
Type | String | A |
Width | [maximum length of subject Unique Identifier string across all the subjects] | [maximum length of subject Unique Identifier string across all the subjects] |
Decimals | N/A |
|
Label | Person ID | Person ID |
Values | None |
|
Missing | None |
|
Columns | [maximum length of subject Unique Identifier string across all the subjects] | [maximum length of subject Unique Identifier string across all the subjects] |
Align | Left |
|
Measure | Unknown |
|
Subject Attribute: Secondary ID
SPSS Data Definition Property | Value | Encoding |
Name | SecondaryID | SecondaryID |
Type | String | A |
Width | [maximum length of subject Secondary Identifier string across all the subjects] | [maximum length of subject Secondary Identifier string across all the subjects] |
Decimals | N/A |
|
Label | Secondary ID | Secondary ID |
Values | None |
|
Missing | None |
|
Columns | [maximum length of subject Secondary Identifier string across all the subjects] | [maximum length of subject Secondary Identifier string across all the subjects] |
Align | Left |
|
Measure | Unknown |
|
Event Attribute: Event Location
SPSS Data Definition Property | Value | Encoding |
Name | LOCATION_[EVENT HANDLE] | LOCATION_[EVENT HANDLE] |
Type | String | A |
Width | [maximum length of event location string across all the subjects] | [maximum length of event location string across all the subjects] |
Decimals | 0 | 0 |
Label | Location for [EVENT NAME] (EVENT HANDLE) | Location for Event [EVENT NAME] (EVENT HANDLE) |
Values | None |
|
Missing | None |
|
Columns | [maximum length of event location string across all the subjects] | [maximum length of event location string across all the subjects] |
Align |
|
|
Measure |
|
|
Event Attribute: Start Date
SPSS Data Definition Property | Value | Encoding |
Name | STARTDATE_[EVENT HANDLE] | STARTDATE_[EVENT HANDLE] |
Type | Date | ADATE10 |
Width | N/A |
|
Decimals | N/A |
|
Label | Start Date for [EVENT NAME] (EVENT HANDLE) | Start Date for [EVENT NAME] (EVENT HANDLE) |
Values | None |
|
Missing | None |
|
Columns | 10 |
|
Align | Right |
|
Measure | Unknown |
|
Event Attribute: End Date
SPSS Data Definition Property | Value | Encoding |
Name | EndDate_[EVENT HANDLE] | EndDate_[EVENT HANDLE] |
Type | Date | ADATE10 |
Width | N/A |
|
Decimals | N/A |
|
Label | End Date for [EVENT NAME] (EVENT HANDLE) | End Date for [EVENT NAME] (EVENT HANDLE) |
Values | None |
|
Missing | None |
|
Columns | 10 |
|
Align | Right |
|
Measure | Unknown |
|
Event Attribute: Status
SPSS Data Definition Property | Value | Encoding |
Name | EventStatus_ [EVENT HANDLE] | EndDate_[EVENT HANDLE] |
Type | String | A |
Width | [maximum length of event status string across all the subjects] | [maximum length of event status string across all the subjects] |
Decimals | N/A |
|
Label | Event Status For [EVENT NAME] (EVENT HANDLE) | End Date for [EVENT NAME] (EVENT HANDLE) |
Values | None |
|
Missing | None |
|
Columns | [maximum length of event status string across all the subjects] | [maximum length of event status string across all the subjects] |
Align | Right |
|
Measure | Unknown |
|
CRF Attribute: Interview Date
SPSS Data Definition Property | Value | Encoding |
Name | InterviewDate_[EVENT HANDLE]_[CRF HANDLE] | InterviewDate_[EVENT HANDLE]_[CRF HANDLE] |
Type | Date | ADATE10 |
Width | N/A |
|
Decimals | N/A |
|
Label | Interviewer Date For [EVENT NAME] | Interviewer Date For [EVENT NAME] |
Values | None |
|
Missing | None |
|
Columns | 10 |
|
Align | Right |
|
Measure | Unknown |
|
CRF Attribute: Interviewer Name
SPSS Data Definition Property | Value | Encoding |
Name | Interviewer_[EVENT HANDLE]_[CRF HANDLE] | Interviewer_[EVENT HANDLE]_[CRF HANDLE] |
Type | String | A |
Width | [maximum length of interviewer name string across all the event CRFs] | [maximum length of interviewer name string across all the event CRFs] |
Decimals | N/A |
|
Label | Interviewer Name for [EVENT NAME] | Interviewer Name for [EVENT NAME] |
Values | None |
|
Missing | None |
|
Columns | [maximum length of interviewer name string across all the event CRFs] | [maximum length of interviewer name string across all the event CRFs] |
Align | Left |
|
Measure | Unknown |
|
CRF Attribute: CRF Version Status
SPSS Data Definition Property | Value | Encoding |
Name | CRFVersionStatus_[EVENT HANDLE]_[CRF HANDLE] | CRFVersionStatus_[EVENT HANDLE]_[CRF HANDLE] |
Type | String | A |
Width | [maximum length of CRF version status string across all the event CRFs] | [maximum length of CRF version status string across all the event CRFs] |
Decimals | N/A |
|
Label | CRF Version Status For [EVENT NAME] | CRF Version Status For [EVENT NAME] |
Values | None |
|
Missing | None |
|
Columns | [maximum length of CRF version status string across all the event CRFs] | [maximum length of CRF version status string across all the event CRFs] |
Align | Left |
|
Measure | Unknown |
|
CRF Attribute: CRF Version Name
SPSS Data Definition Property | Value | Encoding |
Name | VersionName_ [EVENT HANDLE]_[CRF HANDLE] | VersionName_ [EVENT HANDLE]_[CRF HANDLE] |
Type | String | A |
Width | [maximum length of CRF version name string across all the event CRFs] | [maximum length of CRF version name string across all the event CRFs] |
Decimals | N/A |
|
Label | Version Name For [EVENT NAME] | Version Name For [EVENT NAME] |
Values | None |
|
Missing | None |
|
Columns | [maximum length of CRF version name string across all the event CRFs] | [maximum length of CRF version name string across all the event CRFs] |
Align | Left |
|
Measure | Unknown |
|
The following rules apply to variable names in SPSS:
- Must begin with a letter. Remaining characters can be any letter, any digit, a period, or the symbols @, #, _, or $.
- A $ sign in the first position indicates that the variable is a system variable. The $ sign is not allowed as the initial character of a user-defined variable.
- Avoid ending with a period, since the period may be interpreted as a command terminator.
- Avoid ending with an underscore to prevent conflict with variables automatically created by some procedures.
- Length of name cannot exceed 64 bytes. Sixty-four bytes typically means 64 characters in single-byte languages (for example, English, French, German, Spanish, Italian, Hebrew, Russian, Greek, Arabic, Thai) and 32 characters in double-byte languages (for example, Japanese, Chinese, Korean).
- Cannot include spaces and special characters (for example, !, ?, ‘, and *).
- Must be unique.
- Cannot use reserved keywords: ALL, AND, BY, EQ, GE, GT, LE,LT,NE, NOT, OR, TO, WITH.
- Can use any mixture of uppercase and lowercase characters; case is preserved for display purposes.
- When long variable names need to wrap onto multiple lines in output, SPSS attempts to break the lines at underscores, periods, and changes from lower case to upper case.
OpenClinica follows certain rules for automatically converting an invalid dataset variable name to a valid SPSS variable name:
- If the first character is not a letter, V is used as the first letter (implemented in OpenClinica 3.1.3)
OpenClinica does not correct for other SPSS variable name validity constraints.
A future OpenClinica release may automatically correct for additional SPSS validity constraints. See https://issuetracker.openclinica.com/view.php?id=13686:
- Any invalid characters are replaced with the symbol #
- If the last character is a period or an underscore, it is replaced by #.
- If a name is longer than 64 characters, it is truncated to 64 characters.
- If long variable names result in non-unique names in a data file, sequential numbers are used to replace its letters at the end. By default, the size of sequential numbers is 3.
- If a reserved keyword has been used as a variable name, sequential numbers are appended to it.