Create a Code List for a ColumnΒΆ

Often, numeric data correspond to labelled information. For example, a dataset may use the number 1 to represent Males, and 2 to represent Females. Of course, is much easier to make sense of coded data when the values for each number are documented, so Colectica allows you to do this.

  1. On the Colectica ribbon tab, click the Data Documentation button to ensure the Data Documentation pane is visible.

    ../../../_images/data-documentation-button1.png
  2. In the Data Documentation pane, select the Variable Details tab.

    ../../../_images/variable-details-tab.png

    The Variable Details tab shows details for the column where the cursor is located.

  3. For the Data Type, choose Code.

    ../../../_images/variable-details-set-code-type.png
  4. Click the Create New Code List button.

    ../../../_images/create-new-code-list-button.png
  5. To edit codes, click the button for your code list.

    ../../../_images/code-list-button.png
  6. Add labels for each coded value.

    ../../../_images/enter-category-labels.png