topic Re: dirlistwin in SAS Procedures

dirlistwin

nickb — Mon, 09 Aug 2010 20:15:10 GMT

I looking at grabbing some files based the modification date and trying this with dirlistwin. How do I get dirlistwin to recognize the modification date. My goal is to grab files that are less than 5 day old.

Thanks,
Nick

Re: dirlistwin

Doc_Duke — Mon, 09 Aug 2010 20:55:49 GMT

You will need to modify the macro to get the date modified rather than the date created. Use the dir /? command to see the syntax you need to change for your version of windows. Then modify the first filename command in the macro.

Re: dirlistwin

nickb — Tue, 10 Aug 2010 14:41:30 GMT

Thanks. I got the macro edited so that it will read the correct date. I want to incorporate the date filter and I don't want to hardcode the dates. Do you know a way to do something like this:

%dirlistwin (D:/temp/tmp/images,
OUT=work.temp,
REPORT=N,
MINDATE = "&sysdate."d - 5,
MAXDATE = "&sysdate."d
)

The directory that I'm checking has MANY files and I only want the files that are 5 days old.

Re: dirlistwin

ArtC — Wed, 11 Aug 2010 03:36:11 GMT

In the macro world you will have to force the conversion of the data constant.
One way to do this is with the PUTN function.
[pre]%macro test(now, then);
%put now &now;
%put then &then;
%mend test;
%test(%sysfunc(putn("&sysdate"d,6.)), %eval(%sysfunc(putn("&sysdate"d,6.))-5))
[/pre]

Re: dirlistwin

Robert_Bardos — Wed, 11 Aug 2010 06:31:41 GMT

Just as an aside: using %sysevalf gives you the date value immediately.

Try
[pre]
%put %sysevalf("&sysdate"d) ;
%put %sysevalf("&sysdate"d+0) ;
%put %sysevalf("&sysdate"d-5) ;
[/pre]

When I want to edit the date value in macro logic I tend to use the intnx function like in
[pre]
%let my_date = %sysfunc(intnx(day,"&sysdate"d,-5),ddmmyyp10.) ;
[/pre]
(where I know that syntactically the dot after the format name ain't needed)

Re: dirlistwin

ArtC — Wed, 11 Aug 2010 19:03:40 GMT

Good suggestion on the use of %SYSEVALF. Much simpler.