Updated: 14 December 2021

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