Help!! Excel file check in windows sas

[JasonNC]

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

[Reeza]

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?

[JasonNC]

I am running this off of base sas desktop install

[error_prone]

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.