You could have your daily transaction update program flag a status table once all updates are completed. New_Data="Yes"
You could schedule your SAS job to run hourly and have it check this table for updates. If "Yes", then run the SAS analysis and reports and at the end update the New_Data table in SQL Server, if "No", do nothing.
You will want ACCESS to SQL Server (or ODBC or OLE DB depending on your setup.)
Regards,
Stephen