08-22-2014 11:58 AM
We would like to connect Excel to *.sas7bdat tables in order to facilitate seamless pivot tabling. However, in process of upgrading from SAS 9.3 to SAS 9.4 we no longer see OLE DB provider entries listed under the Data Link Properties dialogue box such as
Strangely all the entries from 9.3 exists (same entries as the above, expect version number says 9.3). We did make sure SAS 9.3 is completely uninstalled using the uninstaller provided and the problem persist. Unfortunately when selected, a dialogue box shows up and indicate that the component is no longer available (which is reasonable given that 9.3 is uninstalled).
This problem persists after running SAS 9.4 install again and selecting install additional component and selecting the SAS OLE DB Provider entry.
Could someone please let me know what could be done to troubleshoot this?
Much thanks in advance,