Hello Friends,
We are having an issue while launching a SAS program in JReview. The program throwing an error during runtime with the error "WARNING: Apparent symbolic reference irpaswd not resolved". It is failing at a step where we are trying to connect to database. It is able to fetch the iruser and irconnect values but not the irpaswd.
Could you please suggest? Please let me know if you need any other details.
Thanks,
Mahesh
Maybe you should talk to your SAS admin for help, or the person who wrote this. But the path to the autoexec is usually found in the SAS config file. It could also be something in the actual application call, so it's hard to say exactly where it's being set.
If your need is urgent, you should contact SAS Tech support, that's why you pay the licensing fee after all.
Note much detail and no code...
The most likely cause of that warning is you have code with &irpaswd somewhere. But no value to a macro variable named irpaswd has had a value assigned using either a %let statement, passed as a parameter or created with one of the interfaces from data step code (call symput or call symputx) or Proc SQl (select into: ).
Best is to provide code up to the point you encounter the warning with the log.
Hi ballardw,
Thanks for the quick reply. Please find below code. This SAS program is being used for JReview reporting. We have even not initialized the variable iruser and connect, but they are picked during the run time except irpaswd. I have also attached the log file.
PFA log file.
Thanks,
Mahesh
You should review the information you've posted and delete anything that may be confidential to your company.
Anyways, you have declared iruser and irconnct, but there's no declaration for the password (line 8, line11) so, yes, it can't find it.
You haven't included it somehow.
Thanks Reeza. I have already removed the company specific confidential information.
In the code we have not initialized the iruser and irconnect variables anywhere. But, it is showing in the log file. Could you please let me know how it is picking during the run time? This is what we are not able to find.
One more thing, usually the DB username and password should not be hard coded right? If we hard code those details the program works fine.
Thanks,
Mahesh
Check for an autoexec file that may be setting those values by default.
If you're running in EG there may project specific settings.
Ideally you have single sign on set up and the account has access to the DB directly and doesn't need to pass a user name or password.
Hi Reeza,
Where can I check the autoexec program? Basically, we are launching the program via JReview (UI) and internally JReview makes a call to SAS program. No where in the sas program we have these variables initialized. But, from somewhere it is bringing those values which we don't have a clue.
Please suggest.
Thanks,
Mahesh
Maybe you should talk to your SAS admin for help, or the person who wrote this. But the path to the autoexec is usually found in the SAS config file. It could also be something in the actual application call, so it's hard to say exactly where it's being set.
If your need is urgent, you should contact SAS Tech support, that's why you pay the licensing fee after all.
Agreed! I have also raised it with SAS technical support.
Thanks much for all your support.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.