The first option below does not work and still has the same error: libname tmp excel 'C:\workspace\test.xlsx'; The second option works beautifully: proc import datafile="c:/workspace/test.xlsx" out=want dbms=xlsx replace; run;<code></code> My understanding is that I do not need pcfile server, since I have using both 64 bit Excel and 64 bit SAS. The following is from the link of SAS Support, "If you are running a 64-bit version of Microsoft Office and SAS on 64-bit Microsoft Windows, you do not need to install SAS PC Files Server, except if you plan to connect from a Linux- or UNIX-based SAS installation."
... View more