I'm trying to import old FoxPro DBF files w/o luck into EG Version 5.1 (5.100.0.13108) Hot fix 13 (64-bit).
I'm new to EG so I'm not programming I use the click by click features.
I tried goin gto File, Import then locating the file but I get an error msg when I try to import.
Do you have the SAS Module Access to PC files? If not you may need a work around such as opening them in Excel or other spreadsheet and save as CSV or other text format.
Yes. I just confirmed that.
Bill,
The 64-bit version of EG 5.1 won't be able to import your DBF files. Earlier releases of EG relied on 32-bit data APIs to import such types, but I think this was dropped from EG 5.1 due to complications with 32-bit/64-bit compatibility.
Update: Actually, if you have 32-bit EG 5.1, you can drag a DBF file from Windows Explorer onto an EG project and the Import Data task will import it. This is a bit of a trick and might not be completely supported if things go wrong, but it worked in my simple tests.
Alternative:
If you had access to a 32-bit version of EG 5.1, you might be able to open these files with the FoxPro OLE DB provider (which is 32-bit only). You would select File->Open->OLEDB to get started.
Chris
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: