10-30-2017 02:43 PM
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
10-30-2017 03:08 PM
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.