Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Option to convert NaN to Missing #43

Open
tk3369 opened this issue Apr 25, 2018 · 0 comments
Open

Option to convert NaN to Missing #43

tk3369 opened this issue Apr 25, 2018 · 0 comments

Comments

@tk3369
Copy link
Owner

tk3369 commented Apr 25, 2018

SAS7BDAT stores all numbers as floating point values. When a value is missing, it stores the number as NaN. Technically, NaN and missing data are different things but in this scenario is more likely the number is missing than a true NaN.

This enhancement request is to treat NaN as missing value when reading the file. The column type effectively changes from vector of Float64 to vector of Union{Missing, Float64}. Such behavior may be requested by the user using a new keyword argument nan_as_missing. Further, this option may be used in conjunction with the column_types argument given that some types e.g. Int do not support NaN.

Ref comments from #32 and #42

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant