SAS Enterprise Guide

Desktop productivity for business analysts and programmers

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

Calcite | Level 5

how to see date of last Excel file update

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

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

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

2 REPLIES 2

Super User

Posted 03-31-2021 01:54 PM (2216 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

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

Thanks for your advice!