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.