DATA Step, Macro, Functions and more

Exporting SAS dataset to Excel error message , in base SAS

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 15
Accepted Solution

Exporting SAS dataset to Excel error message , in base SAS

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


Accepted Solutions
Solution
‎05-27-2017 04:47 PM
Community Manager
Posts: 2,954

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

Posted in reply to rmacarthur

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.

View solution in original post


All Replies
Super User
Posts: 19,814

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

Posted in reply to rmacarthur

What do you mean by 'Export Data function'? 

 

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

Solution
‎05-27-2017 04:47 PM
Community Manager
Posts: 2,954

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

Posted in reply to rmacarthur

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.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 191 views
  • 0 likes
  • 3 in conversation