Solved: how to see date of last Excel file update - SAS Support Communities

🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.

Calcite | Level 5

Calcite | Level 5

how to see date of last Excel file update

Posted 03-31-2021 01:40 PM (3335 views)

Hi, colleagues.

I have an Excel file which is updated every day.

I would like SAS to import data from this file automatically, only if file is already updated today.

Can I run in SAS some function to see the date/time when the Excel file was modified last time?

1 ACCEPTED SOLUTION

Accepted Solutions

Super User

Super User

Re: how to see date of last Excel file update

Posted 03-31-2021 01:54 PM (3319 views) | In reply to Vladislav1

Use the FINFO() function to get the last modified date.
https://support.sas.com/kb/38/267.html

View solution in original post

2 REPLIES 2

Super User

Super User

Re: how to see date of last Excel file update

Posted 03-31-2021 01:54 PM (3320 views) | In reply to Vladislav1

Use the FINFO() function to get the last modified date.
https://support.sas.com/kb/38/267.html

Calcite | Level 5

Calcite | Level 5

Re: how to see date of last Excel file update

Posted 04-01-2021 11:43 AM (3234 views) | In reply to Reeza

Thanks for your advice!

744853-sas-innovate-data-ai (1).jpg

Catch up on SAS Innovate 2026

Nearly 200 sessions are now available on demand in the Innovate Hub.