Importing .dbf files created by Visual Fox Pro

Pitchblend — Thu, 31 May 2012 15:46:58 GMT

I am a new user on a new install trying to read .dbf files.

Any ideas and/or code segments that work would be greatly appreciated.

Thanks

I use the following code to try and import a .dbf file

Proc Import Out = work.eqr1

Datafile = "C:\Documents and Settings\kmb1777\My Documents\My SAS Files\DATAFORMS\EQRDATA\EQR_TRANSACTION_201103.DBF"

DBMS = DBF REPLACE;

run;

I get the following error in my log file:

Proc Import Out = work.eqr1

374 Datafile = "C:\Documents and Settings\kmb1777\My Documents\My SAS

374! Files\DATAFORMS\EQRDATA\EQR_TRANSACTION_201103.DBF"

375 DBMS = DBF REPLACE;

376 run;

ERROR: Invalid or non-supported file specified.

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE IMPORT used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

Re: Importing .dbf files created by Visual Fox Pro

FloydNevseta — Thu, 31 May 2012 16:20:03 GMT

SAS' dbase engine cannot read Visual FoxPro databases. Within Visual FoxPro, the database must be saved as a FoxPro version 2 dbf to make it compatible with the dbase engine, or you can use the Visual FoxPro ODBC driver or OLE DB provider.

http://support.sas.com/kb/34/240.html

topic Importing .dbf files created by Visual Fox Pro in SAS Procedures

Importing .dbf files created by Visual Fox Pro

Re: Importing .dbf files created by Visual Fox Pro