Help using Base SAS procedures

Importing .dbf files created by Visual Fox Pro

Reply
N/A
Posts: 1

Importing .dbf files created by Visual Fox Pro

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

Frequent Contributor
Posts: 101

Re: Importing .dbf files created by Visual Fox Pro

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

Ask a Question
Discussion stats
  • 1 reply
  • 814 views
  • 1 like
  • 2 in conversation