topic Re: Getting Error while doing Proc Import in SAS Programming

Getting Error while doing Proc Import

ambadi007 — Thu, 06 Apr 2017 12:26:26 GMT

Dear Experts,

I am getting the below error while importing the excel file

ERROR: The setting of the SYSPRINT option to "PDFCreator#:1 (redirected 2)" will be ignored because "PDFCreator#:1 (redirected 2)" 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.

I have attached the code also for the reference, Please provide me any solution for this error

proc import out = sic 
   datafile = "R:\CDW Reporting\Input Data\SIC Sector Subindustry Lookup" 
    dbms = excel2000 replace; 
   getnames = yes; 
    run;

Re: Getting Error while doing Proc Import

RW9 — Thu, 06 Apr 2017 12:51:33 GMT

This doesn't really have anything to do with proc import. You have, either in your session or setup files: options sysprint...

Setup to a printer that you no longer have mapped. Check:

http://support.sas.com/kb/1/701.html

Sort out the options statement to a printer you have, or map that named printer.

Re: Getting Error while doing Proc Import

Reeza — Thu, 06 Apr 2017 12:51:38 GMT

Your code doesn't point to an Excel file but to a directory. Do you really have an Excel 2000 format file?

Re: Getting Error while doing Proc Import

ambadi007 — Thu, 06 Apr 2017 13:08:23 GMT

Hi the file SIC Sector Subindustry Lookup is an excel file and the type of file is :- Microsoft Excel 97-2003 Worksheet (.xls)

Re: Getting Error while doing Proc Import

Reeza — Thu, 06 Apr 2017 13:15:04 GMT

Set DBMS as XLS or EXCEL.

Set datafile to the full path ofthe Excel file including filename and extension.

Read the log carefully, the Error you've posted appears from a different part of your code, not the IMPORT procedure.

Re: Getting Error while doing Proc Import

ambadi007 — Thu, 06 Apr 2017 15:30:18 GMT

Hi ,

The error message is not showing when I closed and submitted the programme again, Now it is perfect with out any changes.

Thanks a lot for the suggestions and advices ..

Re: Getting Error while doing Proc Import

ballardw — Thu, 06 Apr 2017 17:48:32 GMT

If you are running parts of code by selecting them in the editor and then running highlighted code sometimes you miss something that should be highlighted. That can lead to some very interesting errors.

Re: Getting Error while doing Proc Import

catnipper — Fri, 25 Jan 2019 20:00:16 GMT

I had the exact same problem. I switched printer preferences while having SAS open.

Closed program and re-ran same code and it worked just fine.