Missing values - Revision history

Nils Duepont at 11:55, 29 November 2024

2024-11-29T11:55:42Z

Atran: Added descriptions of missing codes, including specific ones for indicators where scale == Date

2024-11-29T11:16:53Z

Added descriptions of missing codes, including specific ones for indicators where scale == Date

Nils Duepont at 10:50, 29 November 2024

2024-11-29T10:50:33Z

Nils Duepont at 10:48, 29 November 2024

2024-11-29T10:48:44Z

Nils Duepont at 19:06, 12 September 2024

2024-09-12T19:06:59Z

Nils Duepont at 19:04, 12 September 2024

2024-09-12T19:04:37Z

Nils Duepont at 19:04, 12 September 2024

2024-09-12T19:04:25Z

Nils Duepont at 19:04, 12 September 2024

2024-09-12T19:04:08Z

Nils Duepont at 19:03, 12 September 2024

2024-09-12T19:03:44Z

Nils Duepont at 19:01, 12 September 2024

2024-09-12T19:01:46Z

@@ Line 13: / Line 13: @@
 | -777||Not applicable: Data was not collected because it was not relevant for this specific country or policy.
 |-
-| 9999||No information available: A modification to the code -999 to ensure that the user-defines missing value follows the date time format for indicators of which the scale == Date.
+| 9999||No information available: A modification to the code -999 which ensures that the [[File_upload_guide#Uploading_.22missing.22_or_N.2FA_values|user-defined missing value]] follows the [[Coding_rules#Technical_rules|valid date time format]] for indicators with <code>scale</code> set as "Date".
 |-
-| 8888||Absence of a program: A modification to the code -888 to ensure that the user-defines missing value follows the date time format for indicators of which the scale == Date.
+| 8888||Absence of a program: A modification to the code -888 which ensures that the [[File_upload_guide#Uploading_.22missing.22_or_N.2FA_values|user-defined missing value]] follows the [[Coding_rules#Technical_rules|valid date time format]] for indicators with <code>scale</code> set as "Date".
 |-
-| 7777||Not applicable: A modification to the code -777 to ensure that the user-defines missing value follows the date time format for indicators of which the scale == Date.
+| 7777||Not applicable: A modification to the code -777 which ensures that the [[File_upload_guide#Uploading_.22missing.22_or_N.2FA_values|user-defined missing value]] follows the [[Coding_rules#Technical_rules|valid date time format]] for indicators with <code>scale</code> set as "Date".
 |}

@@ Line 7: / Line 7: @@
 !Suggested code!!Description
 |-
-| -999||No information available
+| -999||No information available: Data was unavailable or could not be found.
 |-
-| -888||Absence of a program
+| -888||Policy does not exist: Data was not collected due to knowledge that the policy either has not been implemented or has been discontinued.
 |-
-| -777||Not applicable
+| -777||Not applicable: Data was not collected because it was not relevant for this specific country or policy.
 |-
-| -9999||Program not (yet) introduded (applies to indicators with introduction years only)
+| 9999||No information available: A modification to the code -999 to ensure that the user-defines missing value follows the date time format for indicators of which the scale == Date.
 |}

@@ Line 1: / Line 1: @@
 The recommended way of flagging "missing data" in WeSIS is by using an exclamation mark in the column <code>user_na_values</code> (cf. [[file formats]]). A detailed description of how to input and upload data containing "missings" can be found in the [[File_upload_guide#Uploading_.22missing.22_or_N.2FA_values|file upload guide]].
-Such a way of flagging missing data is very generic to give the data providers room for defining "missings" in line with their intention. Note that the values have to be of the same type as the indicator's valid ones (i.e., numeric, string, or valid date).
+Such a way of flagging missing data is very generic to give the data providers room for defining "missings" in line with their intention. Note that the values have to be of the same type as the indicator's valid ones (i.e., numeric, string, or [[Coding_rules#Technical_rules|dates]]).
 Still, below you can find a set of "missing codes" that have been agreed upon, and it is '''strongly recommended''' to comply whenever you see fit with your indicator to ensure consistency across WeSIS. If you need more codes for unveiling additional information on other aspects of "missingness" try to add codes that fit the already existing scheme (e.g., using -444, -555 etc.). In this case, please extend the list so that other projects can adopt your suggestion. Keep in mind that you still should document the use of any "missing codes" on each indicator page in the "Quick info box" under "Value labels" to also show up in WeSIS.

@@ Line 1: / Line 1: @@
 The recommended way of flagging "missing data" in WeSIS is by using an exclamation mark in the column <code>user_na_values</code> (cf. [[file formats]]). A detailed description of how to input and upload data containing "missings" can be found in the [[File_upload_guide#Uploading_.22missing.22_or_N.2FA_values|file upload guide]].
-Such a way of flagging missing data is very generic to give the data providers room for defining "missings" in line with their intention.
+Such a way of flagging missing data is very generic to give the data providers room for defining "missings" in line with their intention. Note that the values have to be of the same type as the indicator's valid ones (i.e., numeric, string, or valid date).
 Still, below you can find a set of "missing codes" that have been agreed upon, and it is '''strongly recommended''' to comply whenever you see fit with your indicator to ensure consistency across WeSIS. If you need more codes for unveiling additional information on other aspects of "missingness" try to add codes that fit the already existing scheme (e.g., using -444, -555 etc.). In this case, please extend the list so that other projects can adopt your suggestion. Keep in mind that you still should document the use of any "missing codes" on each indicator page in the "Quick info box" under "Value labels" to also show up in WeSIS.

@@ Line 2: / Line 2: @@
 Such a way of flagging missing data is very generic to give the data providers room for defining "missings" in line with their intention.
-Still, below you can find a set of "missing codes" that have been agreed upon, and it is '''strongly recommended''' to comply whenever you see fit with your indicator to ensure consistency across WeSIS. If you need more codes for unveiling additional information on certain types of "missingness" try to add codes that fit the already existing scheme (e.g., using -444, -555 etc.). In this case, please extend the list so that other projects can adopt your suggestion. Keep in mind that you still should document the use of any "missing codes" on each indicator page in the "Quick info box" under "Value labels" to also show up in WeSIS.
+Still, below you can find a set of "missing codes" that have been agreed upon, and it is '''strongly recommended''' to comply whenever you see fit with your indicator to ensure consistency across WeSIS. If you need more codes for unveiling additional information on other aspects of "missingness" try to add codes that fit the already existing scheme (e.g., using -444, -555 etc.). In this case, please extend the list so that other projects can adopt your suggestion. Keep in mind that you still should document the use of any "missing codes" on each indicator page in the "Quick info box" under "Value labels" to also show up in WeSIS.
 {|class="wikitable sortable" border="1"