SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Read / Write Visal Foxpro Data by SAS

Reply
Regular Learner
Posts: 1

Read / Write Visal Foxpro Data by SAS

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.

 

 

Super User
Posts: 3,256

Re: Read / Write Visal Foxpro Data by SAS

Posted in reply to FallColor

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

 

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

 

Ask a Question
Discussion stats
  • 1 reply
  • 250 views
  • 0 likes
  • 2 in conversation