topic Re: Help!! Excel file check in windows sas in SAS Programming

Help!! Excel file check in windows sas

JasonNC — Mon, 30 Oct 2017 18:43:14 GMT

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

Re: Help!! Excel file check in windows sas

Reeza — Mon, 30 Oct 2017 19:08:54 GMT

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?

Re: Help!! Excel file check in windows sas

error_prone — Mon, 30 Oct 2017 19:08:57 GMT

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.

Re: Help!! Excel file check in windows sas

JasonNC — Mon, 30 Oct 2017 20:38:02 GMT

I am running this off of base sas desktop install