In the exported .csv file, if a variable does not have a set value, it's exported as . It should probably be NULL, "", or NA since will be interpreted as a string when handling the data on the backend site. This happens for variables that have been added and not yet collected (for example occupation), this will never be set for patients that are not included for this followup - and should logically not be 999 (unknown). NULL would be more appropriate?
Suggested change: Export data as "" or NULL when a variable does not have a set value.
In the exported .csv file, if a variable does not have a set value, it's exported as. It should probably be NULL, "", or NA since will be interpreted as a string when handling the data on the backend site. This happens for variables that have been added and not yet collected (for example occupation), this will never be set for patients that are not included for this followup - and should logically not be 999 (unknown). NULL would be more appropriate?
Suggested change: Export data as "" or NULL when a variable does not have a set value.