Hi,
I created an excel file for my job which contains some information which will be used in my code.This excel file will be updated twice a month depending on information provided from other people.
My sas job should run daily.What i am trying to achieve is if the excel file is modified with in the past day or today then it should trigger the sas import i created which reads the excel file and creates a sas dataset.
How to check the last modified date for excel file and if it's updated with in last day or today then trigger the import job to create sas permanent file
Thanks for your support
Are you running this off a desktop install or do you have SAS DI Studio or access to a scheduling tool to batch process your files?
I am running this off of base sas desktop install
Solve this problem with the scheduling features of your operating system.
Getting file-information in SAS is possible with the functions fopen and finfo -> check the documentation, there is an example showing how to get file-information.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.