topic Re: Email Notification with processing time in SAS Programming

Email Notification with processing time

Ujjawal — Sat, 23 May 2015 20:32:40 GMT

Hi Experts,

How can i tell SAS to notify me via email once macro finished processing? Also, can i mention in the email processing time - time taken by macro with the attachment CSV file generated by macro?

%macro replace (input= prac.file1,stats=median,vars=Q1-Q5,output=replaced);

* Generate analysis results ;

proc means data=&input noprint;

var &vars;

output out=dummy (drop=_type_ _freq_) &stats= / autoname;

run;

* Convert to vertical ;

proc transpose data=dummy out=dummy;

run;

* Replace missing with analysis results ;

data &output;

set &input;

array vars &vars ;

do i =1 to dim(vars);

set dummy(keep=col1) point= i ;

vars(i)=coalesce(vars(i),col1);

drop col1 ;

end;

run;

Proc export outfile = &output data ='\user\ujjwal'

dbms =csv;

run;

%mend;

Options mprint nosymbolgen;

%replace (input= prac.file1,stats= median,vars=Q1-Q5,output=replaced);

Re: Email Notification with processing time

BrunoMueller — Sun, 24 May 2015 22:04:34 GMT

You can send emails from a SAS program using FILENAME statement with the EMAIL access method, see here for more information SAS(R) 9.4 Statements: Reference, Third Edition

Re: Email Notification with processing time

sbb — Mon, 25 May 2015 18:22:19 GMT

Also, as to your question about capturing/reporting processing-time: the SAS DATA step function DATETIME() can capture the current date/time into either a SAS DATA step variable or also using SYMPUT you can capture the character-string equivalent to a SAS macro variable. With this coding technique applied, then any SAS code-piece can have a pre-processing (initialization) DATETIME() data capture and a post-processing (clean-up) execution to derive an elapsed time.

And with this information, your options are to either make use of MACRO variable "passing" between the initialization and clean-up code-points to derive an elapsed-time data value -- or otherwise more simplified approach having a SAS temporary dataset with the variable containing the start-time and then having the end-time to compute a duration-execution.