Is there a way SAS can scan a directory for a filename?
I'm trying to automate a monthly reporting process. One of the files I need to use is only updated quarterly. They are kind enough to put the year and month in the file name (0512) and leave the rest of the file name identical. What I would like to do is scan the directory for the files aa0509bb.dbf aa0512bb.dbf and automatically determine which is the most recent and use that in my proc sql to link to other datasets.