I developed a code to send email when a process ends.
But every first time that I run the program appears the following error:
ERROR: Insufficient authorization to access
/is/directory/outbox.dat.
After the first try it works fine.
Can you help me to understand what error is that?
SAS CODE:
DATA WORK.SEND_EMAIL;
ATTRIB NM_PROG LENGTH= $80;
ATTRIB CD_USUARIO LENGTH= $10;
ATTRIB NM_USUARIO LENGTH= $80;
NM_PROG = TRANWRD(&_CLIENTPROJECTNAME., ".egp", "");
CD_USUARIO = &_CLIENTUSERID.;
NM_USUARIO = &_CLIENTUSERNAME.;
RUN;
DATA _null_;
SET WORK.SEND_EMAIL;
CALL SYMPUT('NM_PROG', NM_PROG);
CALL SYMPUT('CD_USUARIO', CD_USUARIO);
CALL SYMPUT('NM_USUARIO', NM_USUARIO);
RUN;
PROC OPTIONS
GROUP=EMAIL;
RUN;
DATA _null_;
FILE OUTBOX;
PUT "Srs.,";
PUT "</br>Informo que o programa <b><i>&NM_PROG.</i></b> chegou ao fim do processo.";
PUT "</br></br><b>Executado por:</b> &NM_USUARIO.</br>";
RUN;
%PUT _ALL_;
FILENAME OUTBOX EMAIL
TO='email@email.com.br'
TYPE='TEXT/HTML'
SUBJECT="SAS - &NM_PROG. ";
move FILENAME OUTBOX statment before using it.
That is:
...
FILENAME OUTBOX EMAIL TO='email@email.com.br' TYPE='TEXT/HTML' SUBJECT="SAS - &NM_PROG. ";
DATA _null_; FILE OUTBOX; PUT "Srs.,"; PUT "</br>Informo que o programa <b><i>&NM_PROG.</i></b> chegou ao fim do processo."; PUT "</br></br><b>Executado por:</b> &NM_USUARIO.</br>"; RUN;
move FILENAME OUTBOX statment before using it.
That is:
...
FILENAME OUTBOX EMAIL TO='email@email.com.br' TYPE='TEXT/HTML' SUBJECT="SAS - &NM_PROG. ";
DATA _null_; FILE OUTBOX; PUT "Srs.,"; PUT "</br>Informo que o programa <b><i>&NM_PROG.</i></b> chegou ao fim do processo."; PUT "</br></br><b>Executado por:</b> &NM_USUARIO.</br>"; RUN;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.