Is there a macro to find the last refreshed time of the excel sheet?
?? SAS Macros are not Excel macros. So no, there is no SAS Macro to find something from another application. You perhaps want to consult an Excel forum, e.g.
Then save that refresh date in the date so you can read it in.
Use the right tool (Maxim 14), which is VBA, the dedicated programming environment for MS Office. I don't know if SAS could retrieve that date in any way through dictionary.tables when a library is assigned to the Excel workbook.
I am afraid I don't use that. What I would say is that is just a tool to pull data from a dataset, so its how that pull is done, and recording the datetime of that, e.g:
http://support.sas.com/kb/40/982.html
It would need to be stored in the datafile to be accessible, wouldn't think there is a property for that, but as I say I don't use.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.