topic Re: Exporting SAS dataset to Excel error message , in base SAS in SAS Programming

Exporting SAS dataset to Excel error message , in base SAS

rmacarthur — Sat, 27 May 2017 13:23:33 GMT

Hi,

I have a new installation of SAS ver 9.4 running on a computer that I must log into remotely using LOGMEIN.

When I try to export a SAS dataset using the "EXPORT DATA" function, I receive the following error:

ERROR: The setting of the SYSPRINT option to "Adobe PDF via LogMeIn" will be ignored
because "Adobe PDF via LogMeIn" is not the name of a currently installed printer.
This error may be due to changes in SYSPRINT option syntax.
Please refer to your host companion for details of those changes.
ERROR: Connect: Class not registered
ERROR: Error in the LIBNAME statement.
NOTE: Export Cancelled.

Any suggestions? Thank you

Re: Exporting SAS dataset to Excel error message , in base SAS

Reeza — Sat, 27 May 2017 14:56:11 GMT

What do you mean by 'Export Data function'?

Is that the GUI or via code such as PROC EXPORT?

Re: Exporting SAS dataset to Excel error message , in base SAS

ChrisHemedinger — Sat, 27 May 2017 15:06:37 GMT

I think this is 2 different issues. The Export error might be due to 32 vs 64 bit. Try DBMS=XLSX instead of DBMS=EXCEL.

The printer might be picked up because of your network config. If you can, add -NOPRNGETLIST to your SAS config/startup. This tells SAS not to look for the network printers.