Prev: grouping medical procedure codes using ranges of codes
Next: ODS HTML output from multiple input locations
From: Ken Barz on 25 Jan 2010 15:40
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
 | 
Pages: 1
Prev: grouping medical procedure codes using ranges of codes
Next: ODS HTML output from multiple input locations