topic Re: Import file from last date in SAS Programming

Import file from last date

Ronein — Sun, 02 Dec 2018 12:17:41 GMT

Hello

Let's say that there are multiple txt files with different dates.

For example:

A181127.TXT

A181128.TXT

A181129.TXT

A181130.TXT

The task is to tell SAS to import one file only that will be the file with last date.

How can I do it please?

One option is to find the last file by its file name which has date.

Other option is to find the last file by the date it was created (Import the file that was created last)

Joe

Re: Import file from last date

PaigeMiller — Sun, 02 Dec 2018 12:43:29 GMT

You could use the %DIRLISTWIN macro to read the file names and file dates.

http://support.sas.com/kb/24/820.html

Re: Import file from last date

ChrisNZ — Sun, 02 Dec 2018 20:54:17 GMT

This macro has a few limitations such as requiring pipe access, expecting an English language OS, and expecting AM PM times rather than a 24 hour clock.

If that's not your setup, a much more usable (but less feature-rich) macro is provided here by @BrunoMueller. Still for Windows only though.