mail scheduled in SAS Management console not giving desired output

[SASUserRocks]

Dear Programming Friends

Need a help here a bit. I have developed a script that will process an excel file and send email to recipients based on certain conditions and the processing is inside macros. Not sure why while scheduling the job, not getting desired output.

Program runs fine when manually executed in EG. Attaching code, emails for reference.

Content when triggered manually :-

********************************************

Dear Shamsa Aljaradi, This is test email from SAS as part of ICCS Notification automation

Seeking your kind attention to the below pending cheque in Referral queue. The details are appended in below table for your easy reference. Kindly clear the same in case you wish to proceed.

S.No.	QUEUENAME	BUSINESSCATEGORY	PROFITCENTER	RMCODE	RMNAME	CUSTOMERNAME	CUSTACCOUNTNO	AMOUNT	ODTODATPOSTING	REFERREDREASON
428	ICCSInward_Referral	AUHCORP	622	COR100124	Shamsa Aljaradi	ABU DHABI MAINTENANCE AND CONSTRUCTION COMPANY	252537920024	18612	2445.03	ACCOUNT FORCEPOSTED

Note: This is an automated email from SAS.

Any questions please reach out to CIBG Service quality Team.

Thankyou,

Content when triggered via scheduler:-

********************************************

The SAS System

Dear &RM_Name, This is test email from SAS as part of ICCS Notification automation

Seeking your kind attention to the below pending cheque in Referral queue. The details are appended in below table for your easy reference. Kindly clear the same in case you wish to proceed.

Note: This is an automated email from SAS.

Any questions please reach out to CIBG Service quality Team.

Thankyou,

[ballardw]

What exactly does "not giving desired output" mean? Does this mean you get no output? No email? An email but no attachment?

I would suggest setting OPTIONS MPRINT; in the code calling the macros so the log will have more details about the code actually generated.

Then when the SCHEDULER runs the program, show us the entire log for the process.

Since the LOG is text if there are any bits that might be sensitive then replace them with XXXX or 11111 or similar as seems likely.

Best is to copy the log text with the generated code and all the notes or messages. Then on this forum open a text box with the </> icon above the message box and paste the log. Having to work with attachments is bit a problem for some of us so the text box is a better approach.

[SASUserRocks]

I mean i am getting an email without proc report and dynamic/calculated RM Name when i run through scheduler. Unfortunately i am not sure how to retrieve logs, also unable to schedule any more new job due to unable to save metadata error. Planning to take help from sas admin tomorrow. However one change i made to code so far is changing all work library to existing library because i feel somehow the proc import and other queries are not executing properly through deployed job.

[SASUserRocks]

Also i am getting file attachment correctly. proc report is missing as well Please check the code and email attached along with.

[Sajid01]

Hello @SASUserRocks 
Please have a look at the following
https://communities.sas.com/t5/SAS-Communities-Library/How-to-send-email-using-SAS/ta-p/746523#odsfm...

https://communities.sas.com/t5/SAS-Programming/send-email-from-SAS-add-reports-and-text-in-body-of-e...

These should help.