Displaying 2 results from an estimated 2 matches for "stillgives".
2005 Jan 12
0
RODBC package -- sqlQuery(channel,.....,nullstring=0)stillgives NA's
(1) I do read the posting guide (the fact that I missread o
missunderstood something does not imply not reading)
(2) I could change NAs to 0 (I know) but I have previously (older
versions of R and SQL*Plus) used the same select with the "right" output
(namely with 0s).
(3) AFAIK "strange" is not a negative remark and does not seem to me at
the very least but that is always a
2005 Jan 12
1
RODBC package -- sqlQuery(channel,.....,nullstring=0) stillgives NA's
There is something strange in R behaviour (perhaps).
I have run the same select in Oracle SQL*Plus (version 10.1.0.2.0) and
the output comes out with NULLs (which is what it ougth to be).
But in R I still get the same result with NAs (no matter I use
na.strings or nullstring arguments)
An output example follows below:
Using na.string="0" and nullstring="0" (sorry by the