I asked this question in the new SAS Deployment community here is the link: Paul Homes wrote: Hi, In terms of configuration and administration, I would start out by looking in the SAS/ACCESS(R) 9.2 Interface to PC Files: Reference, Second Edition under LIBNAME Statement and Pass-Through Facility on Linux, UNIX, and 64-Bit Microsoft Windows and then PC Files Server Administration. Cheers Paul Resa wrote: 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. http://communities.sas.com/message/104758#104758
... View more