https://communities.sas.com/t5/SAS-Enterprise-Guide/Return-the-date-a-table-was-last-loaded/m-p/470190#M30502 <P>Check sashelp.vtable, the variable crdate and modate contain creation and modification date of any dataset in an assigned library.</P> Thu, 14 Jun 2018 05:08:44 GMT andreas_lds 2018-06-14T05:08:44Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Return-the-date-a-table-was-last-loaded/m-p/470189#M30501 <P>Hi all,&nbsp;<SPAN>Long-time reader, first-time poster here and relatively new to SAS, so pretty excited to be here.</SPAN></P><P><SPAN>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.</SPAN></P><P><SPAN>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.</SPAN></P><P><SPAN>Any ideas best way to go - using SAS EG 7.12</SPAN></P><P><SPAN>Many thanks, Pete</SPAN></P> Thu, 14 Jun 2018 04:38:02 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Return-the-date-a-table-was-last-loaded/m-p/470189#M30501 ol_mate 2018-06-14T04:38:02Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Return-the-date-a-table-was-last-loaded/m-p/470190#M30502 <P>Check sashelp.vtable, the variable crdate and modate contain creation and modification date of any dataset in an assigned library.</P> Thu, 14 Jun 2018 05:08:44 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Return-the-date-a-table-was-last-loaded/m-p/470190#M30502 andreas_lds 2018-06-14T05:08:44Z