Reuse a Code ListΒΆ

Often, numeric data correspond to labeled 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 coded data when the values for each number are documented, so Colectica allows you to do this.

See also

For instructions on creating a new code list for a column, see Create a Code List for a Column.

Additionally, you can re-use a code list if it applies to multiple columns.

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

    ../../../_images/data-documentation-button.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 Use Existing Code List button.

    ../../../_images/use-existing-code-list-button.png

    After clicking the Use Existing Code List button, a list of available code lists from your workbook is displayed.

  5. Double click the code list you would like to use.

    ../../../_images/code-list-picker.png
  6. The code list will be displayed in the Variable Details pane.

    ../../../_images/code-list-selected.png