04-06-2017 08:26 AM
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;
04-06-2017 08:51 AM
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:
Sort out the options statement to a printer you have, or map that named printer.
04-06-2017 09:15 AM
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.
04-06-2017 11:30 AM
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 ..
04-06-2017 01:48 PM
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.