The PC File Server fails when the server name specified in the IMPORT procedure's SERVER= option is more than 31 characters.

When you use the IMPORT and EXPORT procedures with the PC File Server, you use the SERVER= option to specify the connecting server, as shown:

   proc export dbms=excelcs
               data=sasuser.baseball
               outfile="c:\sastest\testpcserver.xls" replace;
               sheet=mydata;
               server="averlongservername.myservera.com";
               port=8621;
   run;

If the server name is more than 31 characters, you can receive the following error message:

   ERROR: Failed to connect to the Server: averlongservername.myservera.co
   NOTE: The SAS System stopped processing this step because of errors.
   NOTE: PROCEDURE IMPORT used (Total process time):

In the message, the original server name (in this case, averlongservername.myservera.com) is truncated to averlongservername.myservera.co.

To circumvent the problem, you need to specify an IP Address in the SERVER= option rather than the fully qualified server name, as shown in this example:

   proc export dbms=excelcs
               data=sashelp.class
               outfile="c:\sastest\testpcserver.xls" replace;
               sheet=class;
               server="10.11.13.39";
               port=8621;
   run;

Operating System and Release Information