Hello
I want to run SAS program everyday.
Instead of run it manually everyday I want to run it automatically.
Let's say that everyday the data set "cars" is created and IF the data set exists then need to run the program.
If data set cars doesn't exist then no need to run the program.
What is the way to do it please?
The task is to add the element of automatic running to the code below
Data cars;
set sashelp.cars;
Run;
proc sql;
create table Report1 as
select make,
sum(Invoice) as Total_Invoice format=comma23.,
count(*) as nr_rows format=comma23.,
calculated Total_Invoice/(select sum(Invoice) as Total_Invoice from sashelp.cars Where Origin='Europe') as PCT_Total_Invoice format=percent8.1,
calculated nr_rows/(select count(*) as Total_nr from sashelp.cars Where Origin='Europe') as PCT_nr_rows format=percent8.1
from cars
Where Origin='Europe'
group by make
order by Total_Invoice desc
;
quit;
proc export data=Report1 dbms=xlsx outfile="/usr/local/SAS/SASUsers/LabRet/UserDir/Report1.XLSX" replace;
run;
data _null_;
file sendit email
from="<Bob.Dave@gmail.com>"
to=("<Bob.Dave@gmail.com>")
cc=("<Bob.Dave@gmail.com>","<Bob.Dave@gmail.com>")
subject="Important Document"
importance="High"
attach=("/usr/local/SAS/SASUsers/LabRet/UserDir/udclk79/cars_Report.XLSX"
content_type="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
put "Please find attached the file";
put;
put "Thanks!";
run;
