HI I have a table that tracks compliance results. what I'm needing is a count of days the compliance has failed greater than 30 days .once a compliance has been done successfully it falls from report. In my table I  determine compliance with a yes or no  for example TID1 last time compliance done.   Count of date.  1          08/01/2013.                        40 once there is a compliance done than it falls out of the report THanks for your assistance ... View more

HI enclose is the script that will send a text to my sprint phone .once report runs  but I get a box asking for me to ALLOW  or DENY. How can I bypass ? if i select ALLOw it does send the text message filename myemail EMAIL to="##########@messaging.sprintpcs.com" from="first.last@domain.com" sender="first.last@domain.com" subject="SAS "; data _null_; file myemail; put "SAS "; put "Seattle, Washington"; put "April 11-14"; run; filename myemail clear; The script below allows me to send an email with out having to select allow or deny. i change it up where my number would be a person email address. The a error I get is email is invalid. Thanks for your assistance on this options EMAILHOST=mailhost.business.email.net emailsys=smtp emailpw={ EMAILPORT=25; filename mymail email to="##########@messaging.sprintpcs.com" subject="Tuesday"; data _null_; file myemail; put "This file is automated"; put "Please Let me know if anything looks wrong" run; ... View more