DATA Step, Macro, Functions and more

Getting Error while doing Proc Import

Reply
Contributor
Posts: 64

Getting Error while doing Proc Import

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; 
Super User
Super User
Posts: 7,997

Re: Getting Error while doing Proc Import

Posted in reply to ambadi007

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.

Super User
Posts: 19,877

Re: Getting Error while doing Proc Import

Posted in reply to ambadi007

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

Contributor
Posts: 64

Re: Getting Error while doing Proc Import

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

Super User
Posts: 19,877

Re: Getting Error while doing Proc Import

Posted in reply to ambadi007

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. 

Contributor
Posts: 64

Re: Getting Error while doing Proc Import

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 ..

Super User
Posts: 11,343

Re: Getting Error while doing Proc Import

Posted in reply to ambadi007

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.

Ask a Question
Discussion stats
  • 6 replies
  • 170 views
  • 0 likes
  • 4 in conversation