How confident are you that foxpro booleans can be null? I'm pretty sure
for instance that msaccess' booleans cannot...
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
Sent: Monday, April 12, 2004 4:56 PM
Subject: ODBC and null handling for boolean fields
I frequently use SAS to import data from an Advantage (odbc-compliant)
database...I assign a libname as follows (after setting up a User DSN
for the database):
libname temp odbc
then I create data sets using proc sql.
Today I tried to do the same thing for a FoxPro database. I installed
the most recent FoxPro odbc driver and created a user datasource, as
usual. I didn't get any errors in reading in the FoxPro tables into sas
using proc sql; however, for all of my boolean fields, nulls were
translated to false
(0) in sas. In other words, for Yes/No/null fields, I was instead left
with 1=Yes and 0=null or no. How can I prevent this from happening? I
want a null to stay a null.
Thanks in advance.