01-31-2014 10:17 AM
I am trying to learn how to better interface Excel with SAS. I found an example from a SAS User's Group paper (http://www2.sas.com/proceedings/sugi31/024-31.pdf) that shows the following code:
LIBNAME WrkBk EXCEL 'My Workbook.xls' VER=2002;
LIBNAME WrkBk CLEAR;
When I try running it I get an error message in the log:
ERROR: The EXCEL engine cannot be found.
ERROR: Error in the LIBNAME statement.
I know that I need the SAS/ACCESS Interface to PC Files in order to use the EXCEL engine in the LIBNAME statement. I know I have it because I ran PROC SETINIT; RUN; and I got the following log output:
NOTE: PROCEDURE SETINIT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
Product expiration dates:
---Base SAS Software 29NOV2014
---SAS Integration Technologies 29NOV2014
---SAS/ACCESS Interface to PC Files 29NOV2014
---SAS Workspace Server for Local Access 29NOV2014
---DataFlux Trans DB Driver 29NOV2014
---SAS Framework Data Server 29NOV2014
Does anyone know why I can't use Excel on my machine? I have also noticed that it will not let me import .xls files. I have to use .csv. Maybe this is a technical support question, but I thought I would try here first.
01-31-2014 10:43 AM
My guess is that your machine, like most users, is running 64-bit SAS, but only 32-bit Excel. One would have thought that SAS would have automated such discrepancies by now, but I don't think they have.
While I'm not overly familiar with it, I think you will have to research. download and install a SAS addon that I think is free, namely what I think is called the pc files server.