Protobi

Post Editor

← All help posts

View post

<img src="/uploads/upload/image/5200/direct/1584034346970-1584034346969.png" alt="Recode dialog showing the Codes panel on the left with a "(New code)" button, and the Uncoded values panel on the right listing 8 values: 0, 10, 20, 30, 50, 80, 40, and 70." style="text-align: center; width: 1121px;" class="fr-fic fr-dib">

The "Recode..." dialog is a useful tool for [coding text verbatims](/text-open-end-questions/code-text-verbatims). However, there are other practical use cases for the "Recode..." tool.

You can use the tool to:

1.  Recode values to subsets
2.  Recode values to \[NA\]

## Recode values to subsets

The "Recode..." tool is useful to define and analyze new segmentations of the data. For instance, you can [clone](/how-to/how-to-clone-an-element-on-the-same-tab) an element (e.g. Country) and name it "Region."

<img src="/uploads/upload/image/5200/direct/1579892139723-1579892139723.png" alt="Two data panels showing Country and Region breakdowns with descriptive text about Google Translate functionality. The Country panel displays countries like Australia (7.0%), Czech Republic (7.0%), Germany (7.0%) with blue bars, while the Region panel shows APAC (16.0%), EUROPE (40.0%), MIDDLE EAST (29.0%), and SOUTH AMERICA (15.0%)." style="text-align: center; width: 683px;" class="fr-fic fr-dib">

In the new element, you can recode the country values into regions using the "Recode..." dialog. You can then [press to query](/view-access/click-to-query) in the new element to segment the entire survey by region.

<img src="/uploads/upload/image/5200/direct/1660761103132-1660761103132.png" alt="Recode dialog displaying the Codes panel with "(New code)" and "EUROPE 4" containing Germany, Hellas, Czech Republic, and Austria. The Uncoded values panel shows "(uncoded) 16" with a Search field, Clear button, and a list of 16 countries including Australia, Argentinian republic, Kyrgyzstan, Mexico, and others." style="width: 600px;" class="fr-fic fr-dib">

## Recode values to \[NA\]

Below we have a question, **Q1**, where 5% of respondents answered "0". For analysis, you may not want to include zero values in summary statistics like Mean.

<img src="/uploads/upload/image/5200/direct/1584027830861-1584027830861.png" alt="Bar chart for question Q1 asking "Thinking about your Condition X patients, how many of those are currently receiving a GA (gamma antagonist)?" The chart displays percentage bars for ranges from 0 to 71-80, with the largest bar at 67.0% for "1 to 10", and shows Mean=11.2 highlighted in red box with N=100." style="text-align: center; width: 322px;" class="fr-fic fr-dib">

From the element context menu select "Recode..." to bring up the recoding dialog:

<img src="/uploads/upload/image/5200/direct/1584116366985-1584116366984.png" alt="A context menu displayed over a bar chart showing options including "Select to copy as text", "Copy as image", "Round by...", "Statistics...", "Color...", "Format...", "Recode..." (highlighted in red with shortcut E R), "Filters...", "Chart type...", "More properties...", and "Edit JSON..."." style="text-align: center; width: 286px;" class="fr-fic fr-dib">

From here you can filter, select and drag responses to existing or new categories. For this example, we only want to code zeros to "\[NA\]".

<img src="/uploads/upload/image/5200/direct/1584028357207-1584028357207.png" alt="Recode dialog showing the Codes panel with "(New code)" button and an "[NA] 1" code containing the value 0. The Uncoded values panel displays "(uncoded) 7" with a list of seven numeric values: 10, 20, 30, 50, 80, 40, and 70." style="text-align: center; width: 847px;" class="fr-fic fr-dib">

**Q1** now doesn't appear to have any 0 values, and Mean has increased. You can press the [\[NA\] button](https://help.protobi.com/viewaccess/na-blank-missing-values#Exclude%20missing%20values%C2%A0-1) to toggle whether missing values are included in the basis or not.

<img src="/uploads/upload/image/5200/direct/1584032552511-1584032552511.png" alt="Bar chart for Q1 asking about Condition X patients receiving GA, now displaying "[NA]" as the first category at 5.0%, followed by ranges 1 to 10 (67.0%), 11 to 20 (16.0%), and others. The Mean value is shown as 11.8 in a red box, with N=100." style="text-align: center; width: 348px;" class="fr-fic fr-dib">

Publishing

Date

Status

Slug edit

Content

Thumbnail

Categories Manage

Tools

AI Database

Danger zone