About Bottoni

Bottoni · ‎03-09-2017

Thank you very much Shmuel. "Did you mean to sleap 60 seconds, and then what do you want to do ?" After that, I want verify again if the data has refreshed and run a "query". Otherwise I call the funcion sleep again. "Have you considered a situation where" maior_dia > dia_menos_2 Yes, I do. The data refreshes each two days, because of that maior_dia (last day that appears in the data) will never be greater than dia_menos_2 (today - 2).

Shmuel · ‎12-26-2016

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 "Informo que o programa &NM_PROG. chegou ao fim do processo."; PUT "Executado por: &NM_USUARIO."; RUN;

Bottoni · ‎12-26-2016

Thank you for the answer! I changed the file "ENVIAR" to OUTBOX. The error stopped but it continued send a blank email. So I put the "DATA FILE OUTBOX" before the code to send email and it worked.

Peter_C · ‎11-28-2016

modified date is returned by the FINFO() function. See http://support.sas.com/documentation/cdl/en/hostwin/69955/HTML/default/viewer.htm#n0vegoaf5t6s31n1wu1qok4swqye.htm

Bottoni · ‎11-25-2016

I've tryed it. Doesn't work in the company where I work. SAS Administrators say it doesn't work because there the app is virtualized.

Online Status	Offline
Date Last Visited	‎04-20-2017 07:47 AM

Re: Max date (DATA SET)

Max date (DATA SET)

SEND EMAIL ERROR

Re: Email body error

Email body error

Verify file date windows

Re: SAS MACRO WITH SLEEP FUNCTION

Re: SAS MACRO WITH SLEEP FUNCTION

SAS MACRO WITH SLEEP FUNCTION

Re: Max date (DATA SET)

Re: SAS MACRO WITH SLEEP FUNCTION

Re: SAS MACRO WITH SLEEP FUNCTION

Re: SAS MACRO WITH SLEEP FUNCTION

Re: Max date (DATA SET)

Re: SEND EMAIL ERROR

Re: Email body error

Re: Verify file date windows

Re: SAS MACRO WITH SLEEP FUNCTION