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
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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.