Missing values - Revision history

Nils Duepont at 11:55, 29 November 2024

2024-11-29T11:55:42Z

← Older revision		Revision as of 11:55, 29 November 2024
Line 13:		Line 13:
	\| -777\|\|Not applicable: Data was not collected because it was not relevant for this specific country or policy.		\| -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".
	\|-
	~~\| -9999\|\|Program not (yet) introduced (applies to indicators with introduction years only)~~.
	\|}		\|}

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

← Older revision		Revision as of 11:16, 29 November 2024
Line 7:		Line 7:
	!Suggested code!!Description		!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.
			\|-
			\| 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.
			\|-
			\| 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.
			\|-
			\| -9999\|\|Program not (yet) introduced (applies to indicators with introduction years only).
	\|}		\|}

Nils Duepont at 10:50, 29 November 2024

2024-11-29T10:50:33Z

← Older revision		Revision as of 10:50, 29 November 2024
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]].		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.		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.

Nils Duepont at 10:48, 29 November 2024

2024-11-29T10:48:44Z

← Older revision		Revision as of 10:48, 29 November 2024
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]].		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.		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.

Nils Duepont at 19:06, 12 September 2024

2024-09-12T19:06:59Z

← Older revision		Revision as of 19:06, 12 September 2024
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.		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"		{\|class="wikitable sortable" border="1"

Nils Duepont at 19:04, 12 September 2024

2024-09-12T19:04:37Z

← Older revision		Revision as of 19:04, 12 September 2024
Line 5:		Line 5:

	{\|class="wikitable sortable" border="1"		{\|class="wikitable sortable" border="1"
	!Suggested ~~column name~~!!Description		!Suggested code!!Description
	\|-		\|-
	\| -999\|\|No information available		\| -999\|\|No information available

Nils Duepont at 19:04, 12 September 2024

2024-09-12T19:04:25Z

← Older revision		Revision as of 19:04, 12 September 2024
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.		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 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.

	{\|class="wikitable sortable" border="1"		{\|class="wikitable sortable" border="1"

Nils Duepont at 19:04, 12 September 2024

2024-09-12T19:04:08Z

← Older revision		Revision as of 19:04, 12 September 2024
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.		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 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.

	{\|class="wikitable sortable" border="1"		{\|class="wikitable sortable" border="1"

Nils Duepont at 19:03, 12 September 2024

2024-09-12T19:03:44Z

← Older revision		Revision as of 19:03, 12 September 2024
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]].		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]].
	~~This~~ 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.

	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 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.

Nils Duepont at 19:01, 12 September 2024

2024-09-12T19:01:46Z

← Older revision		Revision as of 19:01, 12 September 2024
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]].		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]].
	This 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~~!''~~		This 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.

	{\|class="wikitable sortable" border="1"		{\|class="wikitable sortable" border="1"