topic Auto import with unique name on file in SAS Programming

Auto import with unique name on file

Gil_ — Mon, 15 May 2017 21:59:33 GMT

Hi I want to import a file that will be automate the file has the day the file ran for example pop 05-14-17
How do I auto import where I need the most current file that is dated ? Thanks

Re: Auto import with unique name on file

Reeza — Mon, 15 May 2017 22:06:27 GMT

You find a way to identify the most recent file then import that file. How do you currently identify the most recent file?

You need to provide WAY more information if you want anything beyond this.

Also, search on here, there's been some very recent posts asking almost the identical question, based on a guess of what you're trying to do. But you can't code of guesses.

Re: Auto import with unique name on file

Gil_ — Tue, 16 May 2017 05:48:01 GMT

My import function looks like this

Proc import out =bird
Datafile="\\bird\bird.xlsx"
DBms=excel replace;
Sheet="bird";
Getnames=yes;
Rin;

The files currently looks like this I would need the most current one
Bird-05-14-17.xlsx
Bird-05-13-17.xlsx
Bird-05-12-17.xlsx