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.
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
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.