DATA Step, Macro, Functions and more

SAS excel macro

Reply
New Contributor
Posts: 4

SAS excel macro

Is there a macro to find the last refreshed time of the excel sheet?

Super User
Super User
Posts: 9,599

Re: SAS excel macro

??  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.

https://www.mrexcel.com/forum/excel-questions/106612-display-date-when-data-last-refreshed-external-...

 

Then save that refresh date in the date so you can read it in.

New Contributor
Posts: 4

Re: SAS excel macro

Hi,

Sorry,I am very new to this. Actually I am using excel with SAS add-in. I wanted to know the macro to find out the last refreshed time of the sheet. Can You help me in this?


Super User
Posts: 10,258

Re: SAS excel macro

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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Super User
Super User
Posts: 9,599

Re: SAS excel macro

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.

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