topic Re: Need help to include macro variable values in email in SAS in SAS Programming

Need help to include macro variable values in email in SAS

Banu — Fri, 21 Apr 2017 07:24:00 GMT

Hi,

My exact task is, I have to show few data values which needs to take values from SAS tables using SAS macro variables and should show in email body. And below is the email smaple body.

Mail body required;

Report for April 2017, the total sales amount is 90,500.50.

In these, Electronics amount is 20,500 and other business area amountsare (50,300.50), and (20,000.10).

Caustion:

All above information is strictly confidentail and not sharable.

To do this, I just started below code and then trying to execute below code but macro variables are not resolved in email using X command. Please suggets me how can we achieve above task

data _null_;

x=today();

y=put(x,date9.);

put y;

call symput('getdate',y);

run;

%put &getdate;

%sysexec export rundate=&getdate;

%sysexec echo $rundate;

x 'echo "Run monthly job only on &getdate." | mailx -s "Mail Notification" banu.kumar@xxxxx.com;

Re: Need help to include macro variable values in email in SAS

ArtC — Fri, 21 Apr 2017 07:45:22 GMT

Are you sure that &GETDATE never resolves - not even in the %PUT?

In the X statement you have a mismatched single quote. Also you cannot surround a macro reference with a single quote and still get resolution. There are several ways to get around this, try this general form of the X statement:

x %tslit(echo "&getdate");

Re: Need help to include macro variable values in email in SAS

Kurt_Bremser — Fri, 21 Apr 2017 10:44:13 GMT

%sysexec export rundate=&getdate;
%sysexec echo $rundate;

Both of these commands start a shell; since the change in the environment (new environment variable rundate) is lost when the first shell terminates, the second command won't find $rundate.

Only certain UNIX commands (cd, pwd, setenv, umask) are executed so that they have effect in the context of the SAS session itself.

Re: Need help to include macro variable values in email in SAS

Banu — Fri, 21 Apr 2017 10:53:31 GMT

Thanks for your sugegstion. It's helpful for me.

Re: Need help to include macro variable values in email in SAS

Banu — Fri, 21 Apr 2017 10:55:06 GMT

It's working fine. Thanks

Re: Need help to include macro variable values in email in SAS

Banu — Fri, 21 Apr 2017 11:08:17 GMT

Is there any option to bold values in echo command in SAS X statement.

x %tslit(echo "Total sales amount is: $500,200.10");

OUTPUT require as: Total sales amount is: $500,200.10

Please suggest me.

Re: Need help to include macro variable values in email in SAS

Kurt_Bremser — Fri, 21 Apr 2017 11:44:11 GMT

@Banu wrote:

Is there any option to bold values in echo command in SAS X statement.

x %tslit(echo "Total sales amount is: $500,200.10");

OUTPUT require as: Total sales amount is: $500,200.10

Please suggest me.

No. echo is a UNIX commandline command that can only handle pure text, without any formatting. Also keep in mind that a data step used to create a mail message (using filename email) can only handle text.

But you can use that data step to write HTML code into the mail, which allows you to use HTML formatting tags. An example for this can be found in http://support.sas.com/resources/papers/proceedings10/060-2010.pdf

Re: Need help to include macro variable values in email in SAS

Banu — Fri, 21 Apr 2017 12:48:36 GMT

I have tried same as you mentioned, but getting "ERROR: Email: The connection was refused."

I have given options like emailhost and emailsys. Any suggestions on this?

Re: Need help to include macro variable values in email in SAS

Kurt_Bremser — Fri, 21 Apr 2017 12:54:22 GMT

So your first task should be to make a very simple, "hello world" type mail work with filename email.

"Connection refused" might indicate that

- there is no SMTP server active on the host you named

- it requires credentials

- it only accepts connections from certain clients

Check with your mail administrator how to access the SMTP server.