Variable types

Creating a computed variable you have several variable types to choose from. The different types are listed in the table below with information on when they can be used. Depending on what variable type is being created there are different operators and functions available that will help you to combine and adapt the data of the existing variables. The variable types are described in detail here. In the table you can see which operators you can use and it's definitely possible to combine various operators and functions in the same expression as long as they are compatible with the variable type you are about to create.


Variable type
Purpose
Operators
Functions
Single choice scale
Categorical variables that can be used to calculate an average
AND, OR, NOT, LIKE, =, >, <
COUNTRESPONSE, YEAR, MONTH, DAY, #CurrentDate#
Single choice not scale
Categorical variables that can’t be used to calculate an average
AND, OR, NOT, LIKE, =, >, <
COUNTRESPONSE, YEAR, MONTH, DAY, #CurrentDate#
Multiple choice
Categorical variables where respondents might qualify for several answer alternatives
AND, OR, NOT, LIKE, =, >, <
COUNTRESPONSE, YEAR, MONTH, DAY, #CurrentDate#
Open ended
Text variables where respondents are given a text string
+

Open numeric
Numeric variables that can be used in mean, sum, min, max, medium and percentile calculations
+, -, *, /
IF, COUNT, COUNTRESPONSE, MEAN, PERCENT, VALUE
Date
Date variables
+, -