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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.