Auto import with unique name on file

Reply
Contributor
Posts: 68

Auto import with unique name on file

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
Super User
Posts: 18,997

Re: Auto import with unique name on file

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. 

Contributor
Posts: 68

Re: Auto import with unique name on file

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

Ask a Question
Discussion stats
  • 2 replies
  • 118 views
  • 0 likes
  • 2 in conversation