Keyword summary
The following words can be used as field or category names.
asc
An abbreviated form of the ascending keyword.
ascending
Used when defining a category list to specify that it is to be sorted in ascending order. For more information, see
Categorical.
axis
Used to define an axis expression for use in UNICOM Intelligence Reporter. For more information, see
Axis expressions.
block
Used to define a field as a
Block.
boolean
Used to define a field as a
Boolean question.
categorical
Used to define a field as a
Categorical question.
codes
Used to define a codes list. Codes lists are typically used to specify
Don't Know,
No Answer and
Refused to Answer special responses for
Long,
Double,
Text,
Date, and
Boolean questions, and to store the coded responses of Text questions.
column
Used to define that the iterations of a grid, or a loop displayed as a grid, are to be displayed as columns. See
Categorical loop.
compound
Used to define a field as a
Compound.
date
Used to define a field as a
Date variable.
defaultanswer
Used to define a default answer for
Long,
Double,
Text,
Date,
Boolean, and
Categorical questions.
define
Used to define a field as a defined list: see
Define.
deriveelements
Used to specify that an expression in a
Categorical question should derive elements (categories).
desc
An abbreviated form of the descending keyword.
descending
Used when defining a category list to define that it is to be sorted in descending order. See
Categorical.
DK
Used to include the
Don't Know special response in the categories list of a
Categorical question, or the codes list of a
Long,
Double,
Text,
Date, or
Boolean question.
double
Used to define a field as a
Double, which is a numeric question that can accept a real (decimal) number response.
elementtype
Used to define a special element for use during analysis. See
Categorical.
end
Used to define the end of the Metadata section in a script. See
mrScriptMetadata reference.
exclusive
Used to define a single-choice category in a
Categorical question. Typically used in multiple-response questions to define a single-choice category such as
None of the above.
expand
Used to define that the response data for a loop is to be stored in a flattened form. See
Categorical loop.
expression
Used to define an expression for
Long,
Double,
Text,
Date,
Boolean, and
Categorical questions. Generally used to create a derived variable that is based on one or more other variables.
factor
Used to assign a factor value to a category in the category list of a
Long,
Double,
Text,
Date, or
Categorical question. Factors are used for statistical analysis. Also used to assign a boolean value to a category in the category list of a
Boolean question.
false
Used when defining to indicate a False value. Also used to assign a value of FALSE to a category in the category list of a
Boolean question.
fields
fix
Used to specify that a category, or a group of categories, is to retain its original position in the list when the category list, or the set of category groups, is sorted, rotated, randomized, or reversed. See
Categorical.
grid
Used to define a field as a
Grid. Also used to specify that a loop is to be displayed as a grid in a
Categorical loop or a
Numeric loop.
helperfields
Used to create helper variables. See
Helper variables.
info
Used to define a field as an
Info.
initialanswer
Used to define an initial answer for
Long,
Double,
Text,
Date,
Boolean, and
Categorical questions.
inline
Used to specify that the individual categories in a group should be included in the set of categories to be ordered when the overall list of categories is sorted, rotated, randomized, or reversed. See
Categorical.
keycode
Used to specify a custom keycode for individual categories. Keycodes are used in the UNICOM Intelligence Interviewer - Offline for Windows application to help limit the number of keystrokes required when entering response values. See
Categorical.
labelstyle
Used to define the appearance of the label text for a field when an interview takes place. See
Styles and templates.
lcl
Used to identify an area code that identifies a particular language, user context and label type combination. The name must have been defined already in the script. See
Alternative labels.
like
Returns the boolean value True if a text string matches a pattern. See
Like operator.
long
Used to define a field as a
Long question, which is a numeric question that requires a whole number response.
loop
Used to define a set of questions to be asked more than once. There are two types of loops--
Categorical loop and
Numeric loop.
metadata
Used to define the start of the Metadata section in a script. See
mrScriptMetadata reference.
multiplier
Used to define a special type of helper variable that is used to store numeric data associated with a category. See
Categorical loop.
NA
Used to include the
No Answer special response in the categories list of a
Categorical question, or the codes list of a
Long,
Double,
Text,
Date, or
Boolean question.
namespace
Used when defining a category list to indicate that the category names should be namespaced based on the list name. By default, category names do not include a namespace. See
Categorical.
next
1. Defines the end of a
For...Next or
For Each...Next iteration statement.
2. In an error handler, part of a
Resume Next, which transfers execution to the statement following the statement that caused the error.
3. Part of an On Error Resume Next statement, which transfers execution to the statement following a statement that causes an error. See
On Error.
nocasedata
Used to specify that a question does not store case data.
Info automatically have the nocasedata attribute. See
Field definitions.
noderiveelements
Used to specify that an expression in a
Categorical question should not derive elements (categories).
noexpand
Used to define that the response data for a grid is to be stored in a hierarchical form only. See
Grid.
nofilter
Prevents a category from being excluded when using a filter in UNICOM Intelligence Reporter or the UNICOM Intelligence Professional Tables option. See
Categorical.
nonamespace
Used in a
Compound to specify that the name of the compound should be omitted from the full names of the questions nested inside it.
null
Used when defining
Custom properties to indicate a Null value.
other
Used to define an Other Specify category. See
Categorical.
page
Used to define a field as a
Page, which is used to group questions together for displaying as a page.
precision
Used in
Long and
Double questions to specify the total number of digits that will be stored in the case data file when the question is saved. In Double questions, Precision is typically used in conjunction with the
scale keyword, as the value of Precision includes any decimal places in the number.
ran
An abbreviated form of the randomize keyword.
randomize
Used to specify that a category list is to be presented in randomized order. See
Categorical.
REF
Used to include the
Refused to Answer special response in the categories list of a
Categorical question, or the codes list of a
Long,
Double,
Text,
Date, or
Boolean question.
rev
An abbreviated form of the reverse keyword.
reverse
Used to specify that a category list is to be reversed before presentation to each respondent. See
Categorical.
rot
An abbreviated form of the rotate keyword.
rotate
Used to specify that a category list is to be rotated for each respondent. See
Categorical.
row
Used to define that the iterations of a grid, or a loop displayed as a grid, are to be displayed as rows. See
Categorical loop.
scale
Used in
Double questions to specify the number of decimal places that will be stored when the question is saved.
step
Used to specify stepped values in the range expression for a long question. See
Long.
style
Used to define the appearance of the control for a field when an interview takes place. See
Styles and templates.
sublist
Used to specify that the individual categories from a defined list should not be included in the set of categories to be ordered when the overall list of categories is sorted, rotated, randomized, or reversed. See
Categorical.
templates
Used to define the appearance of any aspect of a field when an interview takes place. See
Styles and templates.
text
Used to define a field as a
Text (open-ended) question.
true
Used when defining
Custom properties to indicate a True value. Also used to assign a value of TRUE to a category in the category list of a
Boolean question.
unversioned
Used to specify that a question can be changed at any time, regardless of the lock status of the current version of the metadata. See
Field definitions.
usagetype
Used to specify special variable usage types, such as weight and filter. See
Special usage types.
use
Used when using a
Define.
validation
Used to define validation for open-ended responses. See
Text.
Reserved words
The following list of additional words are reserved keywords in the UNICOM Intelligence Data Model SQL syntax. The words can typically be used as field names, as well as part of a name. For example, “Table” can be used as the name of a question nested inside a loop and can also be used as the name of a simple question.
Add
All
Alter
As
Asc
Avg
Base
Boolean
By
Categorical
Column
Count
Create
Date
Default
Delete
Desc
Double
Drop
Exec
From
Group
Having
Insert
Into
Level
Long
Max
Min
Object
On
Order
Select
Set
Stdev
Sum
Table
Text
Truncate
Update
Value
Values
Where
With
Additional words that can be used for the names of questions
These additional words that can be used for the names of questions that are contained within a loop, block, or compound question.
Categories
Count
Errors
Item
Label
LayoutTemplate
ParentQuestion
Properties
QuestionFullName
QuestionInfo
QuestionName
QuestionType
Style
Value
See also