Monday, March 10, 2008

Grabbing the Data Creation Date

The data table creation date is sometimes necessary, say in the footnote of your stored process. Included below is a sample to retrieve this date from the file system. /*Open the dataset*/ %let dsid=%sysfunc(open(sashelp.shoes)); data _null_; /*grab the CRDTE function*/ ddate=%sysfunc(attrn(&dsid,CRDTE )); /*Format in DDMONYY*/ call symput('ddate', put(ddate, dtdate9.)); run; /*Close the dataset*/ %let rc=%sysfunc(close(&dsid)); //*Sample use of the create dataset macro*/ footnote "Data Refreshed On &ddate"; proc gchart data=sashelp.shoes; vbar sales; run;quit;

0 comments: