Hey everyone. I ended up using this code to make my excel files into SAS files. PROC IMPORT OUT= WORK.data2 DATAFILE= "C:\data1.xlsx"             DBMS=xlsx REPLACE; SHEET="data1";      GETNAMES=YES; RUN; Thank you for all of your help. ... View more

Yes I've tried that too but doesn't work either with excel or excelcs -.- When I followed the link for the PC Files Server it says is only fro SAS 9.3 I wonder if it also works for 9.4 which is what I have... ... View more

When I try the import option and choose the Microsoft Excel Workbook on PC files server this window appears: I will sound very dumb but what would the server name be? cwilson I will check that right now Thank you ... View more

The code I use is: libname census pcfiles path="C:\Users\mzavalza\Documents\Myriam\Census 2010_ACS data_excel\Cens_ZIP_URBAN AND RURAL.xlsx"; RUN; And I get this error: ERROR: Unable to locate pcfserver.exe. Please install PC Files Server. ERROR: Error in the LIBNAME statement. But when I check my SAS license like this: proc setinit; run; I get in the log that I have the pc files ---SAS/ACCESS Interface to DB2          30JUN2015 ---SAS/ACCESS Interface to Oracle          30JUN2015 ---SAS/ACCESS Interface to Sybase          30JUN2015 ---SAS/ACCESS Interface to PC Files          30JUN2015 ---SAS/ACCESS Interface to ODBC          30JUN2015 ---SAS/ACCESS Interface to OLE DB          30JUN2015 ---SAS/ACCESS Interface to Teradata          30JUN2015 ---SAS/ACCESS Interface to MySQL          30JUN2015 I have to use the pc files isnce my SAS version is 64 bit and my excel is 32 bit ... View more