In addition to what Paul Homes indicated:
From experience please take notice of the following Usage Notes:
35064 Network drives are not recognized by the SAS® PC File Server when the server is installed as a service
41060 The EXCELCS and PCFILES engines do not support the GETNAMES= and MIXED= options
The syntax when using EXCELCS is basically as follows:
PROC EXPORT
DATA = <SAS Dataset>
OUTFILE = <Excel file>
DBMS = EXCELCS
REPLACE ;
SERVER = <server name> ;
PORT = <portnumber> ;
SSPI = YES ;
RUN ;
PROC IMPORT
OUT = <SAS Dataset>
DATAFILE = <Excel file>
DBMS = EXCELCS
REPLACE ;
SERVER = <server name> ;
PORT = <portnumber> ;
SSPI = YES ;
RUN ;
We use SSPI=YES to allow Integrated Windows Authentication as described on this page.