DATA Step, Macro, Functions and more

Help!! Excel file check in windows sas

Reply
Regular Contributor
Posts: 160

Help!! Excel file check in windows sas

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

Super User
Posts: 23,228

Re: Help!! Excel file check in windows sas

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?

Regular Contributor
Posts: 160

Re: Help!! Excel file check in windows sas

I am running this off of base sas desktop install

Regular Contributor
Posts: 201

Re: Help!! Excel file check in windows sas

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.

Ask a Question
Discussion stats
  • 3 replies
  • 121 views
  • 0 likes
  • 3 in conversation