Desktop productivity for business analysts and programmers

Return the date a table was last loaded

Reply
Highlighted
Learner
Posts: 1

Return the date a table was last loaded

Hi all, Long-time reader, first-time poster here and relatively new to SAS, so pretty excited to be here.

What I am trying to do is put a dependency check into a program that checks the date a table was last loaded prior to running a proc export, so we don't run an export unless the table has been loaded today.

I know a proc contents would show these attributes, but I am wanting to use an IF statement of sorts to load only if load date is todays date.

Any ideas best way to go - using SAS EG 7.12

Many thanks, Pete

Valued Guide
Posts: 525

Re: Return the date a table was last loaded

Check sashelp.vtable, the variable crdate and modate contain creation and modification date of any dataset in an assigned library.

Ask a Question
Discussion stats
  • 1 reply
  • 64 views
  • 1 like
  • 2 in conversation