topic Re: FInd the last updated dataset in SAS Procedures

FInd the last updated dataset

deleted_user — Tue, 09 Jun 2009 06:54:15 GMT

HI

i have a master table (master_uniq) consitnously we will updaate dataset to that table (50-120 datasets/perday).Now i want the last updated dataset.i have tryed dictionary.vtable also.please let me know

Re: FInd the last updated dataset

deleted_user — Tue, 09 Jun 2009 07:40:05 GMT

Hi,

You can find this using proc contents.

You will have a variable called MODATE which gives you last modified date

check with this.

Hope this will help you

Re: FInd the last updated dataset

DanielSantos — Tue, 09 Jun 2009 11:45:57 GMT

Are you looking ofr the last updated dataset or the last dataset that updated the master table?

For the first, PROC CONTENTS/MODADTE would be a good solution.
You could try also the SYSLAST macro variable which stores the name of the last written dataset.

For the last, you could try to arrange your code to save the desired name on some macro variable, for later processing.

Cheers from Portugal.

Daniel Santos @ www.cgd.pt

Re: FInd the last updated dataset

deleted_user — Tue, 16 Jun 2009 19:47:53 GMT

Hi,

You can use the following logic to get the last modified date of a file:

filename inp pipe "ls -g -o ~/&FileName1";
data _null_;
infile inp firstobs=2;
input @24 ModifiedDate $12. ;
if ModifiedDate=" " then stop;
put ModifiedDate= ;
run;

U can pass the list of all files one by one and record the one with the maximum modified date.
Above code is for UNIX,
for windows use: filename inf pipe "dir &FileName1 /t:w /a:-d"; and read from the 6th observation
in format mmddyy8. and time8.

Re: FInd the last updated dataset

Peter_C — Wed, 17 Jun 2009 06:21:25 GMT

if you update the "master" with PROC APPEND or data step MODIFY, let an AUDIT trail keep the "knowledge".

good luck
PeterC