BookmarkSubscribeRSS Feed
Pitchblend
Calcite | Level 5

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

1 REPLY 1
FloydNevseta
Pyrite | Level 9

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

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 2830 views
  • 1 like
  • 2 in conversation