Introduction

CODE_LIST_TABLE is a table that can be used to specify both missing codes and value labels. This is useful in case there is a great number of tables.

In the item_level metadata, the column MISSING_LIST_TABLE and VALUE_LABEL_TABLE enable to indicate the name of the relative table that should contain the missing or value labels data, as you can see from the following example of an item_level metadata.

## Warning in attr(x, "align"): 'xfun::attr()' is deprecated.
## Use 'xfun::attr2()' instead.
## See help("Deprecated")
VAR_NAMES LABEL DATA_TYPE MISSING_LIST_TABLE VALUE_LABEL_TABLE
7 v01002 SEX_1 integer NA sex_vl
9 v00004 SBP_0 float missing_table part_vl
10 v00005 DBP_0 float missing_table
11 v00006 GLOBAL_HEALTH_VAS_0 float missing_table
26 v00018 EDUCATION_0 integer missing_table edu_vl


CODE_LIST_TABLE for data quality reporting


CODE_VALUE

Can contain two types of values:

  • the different levels associated with missing data or jumps as defined in the study, i.e., the missing categories (see also missings);

  • the possible values corresponding to the levels of a categorical variable.


CODE_LABEL

Sets the interpretation of the codes, usually they correspond to the labels assigned in the study. For example, the code labels may be as follows.

## Warning in attr(x, "align"): 'xfun::attr()' is deprecated.
## Use 'xfun::attr2()' instead.
## See help("Deprecated")
CODE_VALUE CODE_LABEL
2 99981 Missing - exclusion criteria
9 99988 Missing - optional value
1 0 females
21 1 males


CODE_ORDER

Assigns an order to value labels. This can be useful in case of ordinal variables (e.g., low, medium, high).

## Warning in attr(x, "align"): 'xfun::attr()' is deprecated.
## Use 'xfun::attr2()' instead.
## See help("Deprecated")
CODE_VALUE CODE_LABEL CODE_ORDER
2 99981 Missing - exclusion criteria
9 99988 Missing - optional value
1 0 females
21 1 males
3 0 pre-primary 1
4 1 primary 2
5 2 secondary 3


CODE_CLASS

Assigns the meaning of CODE_VALUE and it can contains one of the following:

  • MISSING, the code represents a missing value;

  • JUMP, the code represents a jump value; or

  • VALUE, the code represents a level of a categorical variable.

## Warning in attr(x, "align"): 'xfun::attr()' is deprecated.
## Use 'xfun::attr2()' instead.
## See help("Deprecated")
CODE_VALUE CODE_LABEL CODE_ORDER CODE_CLASS
9 99988 Missing - optional value MISSING
11 99990 Deleted - contradiction MISSING
17 88880 JUMP 88880 JUMP
1 0 females VALUE
2 1 males VALUE
12 0 pre-primary 1 VALUE
21 1 primary 2 VALUE
3 2 secondary 3 VALUE


CODE_LIST_TABLE

The table name used to identify the corresponding information in the item_level metadata.

## Warning in attr(x, "align"): 'xfun::attr()' is deprecated.
## Use 'xfun::attr2()' instead.
## See help("Deprecated")
CODE_VALUE CODE_LABEL CODE_ORDER CODE_CLASS CODE_LIST_TABLE
9 99988 Missing - optional value MISSING missing_table
11 99990 Deleted - contradiction MISSING missing_table
17 88880 JUMP 88880 JUMP missing_table
1 0 females VALUE sex_vl
2 1 males VALUE sex_vl
12 0 pre-primary 1 VALUE edu_vl
21 1 primary 2 VALUE edu_vl
3 2 secondary 3 VALUE edu_vl


CODE_INTERPRET

Defines the interpretation of the missing and jump values using the AAPOR concept. The acronym from AAPOR suffices as an entry. For more details see the explanation on qualified missingness labels from AAPOR.

## Warning in attr(x, "align"): 'xfun::attr()' is deprecated.
## Use 'xfun::attr2()' instead.
## See help("Deprecated")
CODE_VALUE CODE_LABEL CODE_ORDER CODE_CLASS CODE_LIST_TABLE CODE_INTERPRET
9 99988 Missing - optional value MISSING missing_table NE
11 99990 Deleted - contradiction MISSING missing_table O
17 88880 JUMP 88880 JUMP missing_table NE
1 0 females VALUE sex_vl
2 1 males VALUE sex_vl
12 0 pre-primary 1 VALUE edu_vl
21 1 primary 2 VALUE edu_vl
3 2 secondary 3 VALUE edu_vl


Back to Metadata