Decipher Dichotomous Variables Writeback - Naming Convention
Introduction
When writing data back to Decipher using the “Dichotomous Variables” writeback type, multiple questions containing a separate binary value (i.e. column) for each code in the codeframe are created.
The "Dichotomous Variables" approach is fairly simple to understand but leads to a lot of columns.
Some users might prefer the "Expanded Variables" approach to reduce the number of columns: https://dtax.helpsite.com/articles/66221-decipher-expanded-variables-writeback-naming-convention
When Codeit creates these questions in Decipher, it follows a specific naming convention.
This page explains this naming convention.
Naming Convention
In short, the naming convention follows this pattern for each question iteration and code:
<Target Variable Name>[_lVerbatim Level + 1] [_oVerbatim Ordinal + 1] + [Code Number]
To help understand what that means, let’s look at an example.
Simple Example
Suppose we have a set of verbatim data as follows:
| ID |
Q1 |
| 1 |
Service, price and location |
| 2 |
The service was bad |
| 3 |
Great price |
And the following codeframe:
| ID |
Text |
| 1 |
Service |
| 2 |
Price |
| 3 |
Location |
Suppose we code Q1 into a target variable called Q1_coded
If we just apply just one code to each verbatim then the naming of our output questions/columns in Decipher is straightforward:
| ID |
Q1 |
Q1_coded1 |
Q1_coded2 |
Q1_coded3 |
| 1 |
Service, price and location |
1 |
1 |
1 |
| 2 |
The service was bad |
1 |
0 |
0 |
| 3 |
Great price |
0 |
1 |
0 |
Multi-response Example
In addition to multi coding, we sometimes need to handle multi-response verbatims.
For example, suppose Q1 contains brand mentions where the respondent mentions up to 3 brand names, like so:
| ID |
Q1 |
Q1 |
| 1 |
BrandA |
BrandB |
| 2 |
BrandB |
|
| 3 |
BrandB |
BrandA |
And the codeframe:
| ID |
Text |
| 1 |
BrandA |
| 2 |
BrandB |
Since each respondent can give multiple answers to Q1, we again need a way of labelling the multiple outputs. Following the naming convention above, we would label the questions written to Decipher as follows:
| ID |
Q1 |
Q1 |
Q1_codedo11 |
Q1_codedo12 |
Q1_codedo21 |
Q1_codedo22 |
| 1 |
BrandA |
BrandB |
1 |
0 |
0 |
1 |
| 2 |
BrandB |
0 |
1 |
0 |
0 |
|
| 3 |
BrandB |
BrandA |
0 |
1 |
1 |
0 |