Read / Write Visal Foxpro Data by SAS

FallColor — Tue, 15 Sep 2015 17:47:36 GMT

I am seeking a way of directly way of reading Visual Foxpro data in SAS, update data then write it back directly into Visual Foxpro. Using the following syntax could read Visual Foxpro data directly:

libname mylib oledb provider=VFPOLEDB.1 DataSource="H:\" preserve_tab_names=yes; However had problem on writing out data in Visual Foxpro directly using the following syntax:

data mylib.US;

set mylib.country;

run;

ERROR: Execute error: Unable to get create accessor; Error in columns : One or more accessor flags were invalid.

ERROR: ROLLBACK issued due to errors for data set MYLIB.US.DATA.

Re: Read / Write Visal Foxpro Data by SAS

SASKiwi — Wed, 16 Sep 2015 01:27:04 GMT

I suggest you try SQL PASSTHRU similar to this SAS note:

http://support.sas.com/techsup/notes/v8/13/171.html

topic Read / Write Visal Foxpro Data by SAS in SAS Data Management

Read / Write Visal Foxpro Data by SAS

Re: Read / Write Visal Foxpro Data by SAS