May I know how to run other SAS codes based on a table, the table will tell when to run the SAS codes (e.g. how freq i.e daily, weekly or monthly) and also there is a expiry date to tell when to stop the SAS codes
It looks like you are heading down the path of building your own SAS job scheduler. I highly recommend you don't do this. Why? Because there are already many scheduling tools available to you so why build another one. Every operating system has a scheduling tool, like Windows task scheduler. SAS provides scheduling capability using SAS Management Console and the Schedule Manager:
This is a good solution if you are using SAS on a remote server. If you are using SAS on a PC then scheduling using SAS Enterprise Guide is an option. This link shows several options available to you:
https://blogs.sas.com/content/sgf/2013/08/14/four-ways-to-schedule-sas-tasks/
Thanks for your solution!
Please mark this post as answered if you are happy with the solution.
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Check out this tutorial series to learn how to build your own steps in SAS Studio.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.