Date:         Mon, 25 Jan 2010 20:40:45 +0000
Reply-To:     zrab123@COMCAST.NET
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Ken Barz <zrab123@COMCAST.NET>
Subject:      Access to OLEDB Question
Content-Type: text/plain; charset=utf-8

I'm using the following libname to access a Foxpro database:

libname dmsysdb oledb init_string='Provider=VFPOLEDB.1;Data Source=H:\DB\DATAMST\3\DATA\data.DBC';

When I do this, variables that have missing values are coming back as zero. This causes and issue since we can't distinguish between missing and an actual zero. I've tried the options missing=, but proc compare still knows the difference as we're comparing the new VFP database to one started in SAS datasets.

So, I guess the question is: is there something I can add to the libname or init_string to force missing values to come out compliant with SAS. If we open up the VFP table natively, the values are blank, so the issue is in translating it into SAS.
Thanks,
Ken