Date:         Mon, 16 Sep 2002 16:42:59 -0400
Reply-To:     "Brucken, Nancy" <Nancy.Brucken@PFIZER.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Brucken, Nancy" <Nancy.Brucken@PFIZER.COM>
Subject:      Re: modified date of dataset into output.
Comments: To: "Huang, Ya" <ya.huang@pfizer.com>
Content-Type: text/plain; charset="windows-1252"

And the SQL approach  :-)

%macro modat(libname=,dsname=);
%global modat;
proc sql noprint;
  select put(datepart(modat),date.) into :modat
    from dictionary.table
    where libname="%upcase(&libname)" and
          memname="%upcase(&dsname)"
quit;

%mend modat;

Nancy

Nancy Brucken
Development Informatics
Pfizer Global Research & Development, Ann Arbor
(734) 622-5767
E-mail address:  Nancy.Brucken@pfizer.com


-----Original Message-----
From: Huang, Ya [mailto:ya.huang@PFIZER.COM]
Sent: Monday, September 16, 2002 4:27 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: modified date of dataset into output.


How about this ?

data xx;
a='asdasd';
run;

%macro modat(libname=,dsname=);
%global modat;
data _null_;
 set sashelp.vtable (where=(libname="%upcase(&libname)" and
memname="%upcase(&dsname)"));
 call symput('modat',put(datepart(modate),date.));
run;
%mend;

%modat(libname=WORK,dsname=xx);

proc print data=xx;
title4 "data xx was last modified on &modat";
run;

-----------

data xx was last modified on 16SEP02

Obs      a

 1     asdasd

Just call %modat right before where your report start.

I guess you'll see some SCL function + %sysfunc solution
very soon.

Kind regards,

Ya Huang
-----Original Message-----
From: Sue Li [mailto:sli@terrecrs.com]
Sent: Monday, September 16, 2002 1:15 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: modified date of dataset into output.


Hi,

I like my output reflect the modified date for the dataset that I used to
generate the output. Does anyone know how to do it? If any automatic macro
is available for this? Thanks a lot.