Difference between revisions of "Missing values"
Nils Duepont (talk | contribs) |
Nils Duepont (talk | contribs) |
||
| (2 intermediate revisions by 2 users not shown) | |||
| 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 | + | 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. | ||
| 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|| | + | | -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||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 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 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". | ||
|} | |} | ||
Latest revision as of 12:55, 29 November 2024
The recommended way of flagging "missing data" in WeSIS is by using an exclamation mark in the column user_na_values (cf. file formats). A detailed description of how to input and upload data containing "missings" can be found in the 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 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.
| Suggested code | Description |
|---|---|
| -999 | No information available: Data was unavailable or could not be found. |
| -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: 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 which ensures that the user-defined missing value follows the valid date time format for indicators with scale set as "Date".
|
| 8888 | Absence of a program: A modification to the code -888 which ensures that the user-defined missing value follows the valid date time format for indicators with scale set as "Date".
|
| 7777 | Not applicable: A modification to the code -777 which ensures that the user-defined missing value follows the valid date time format for indicators with scale set as "Date".
|
