i was curious about the missing values indicator if i was going to be undertaking sql scripts when dataset is uploaded. is there an R equivalent to na.rm=T in sql to be able to use the data in tabulation. thanks for any information.
Matthew Bellew responded:
2010-06-08 13:44
I had to look this up, so for the record
na.rm a logical value indicating whether NA values should be stripped before the computation proceeds.
awilson responded:
2010-06-08 14:10
R is really nice for dealing with this sort of mvindicator and changing it to NA for the purposes of analysis. however i was curious if there was a comparable method to be found in SQL scripting for NULL/NA values.
cheers
marki responded:
2010-06-09 10:17
Pretty sure that SQL can do what you want, but not sure exactly what you want to do. Do you want to filter out NULL values (WHERE X IS NOT NULL) or map them onto some other value (COALESCE(X, 'Other value'))