How to import unique SAS files from a directory?

[Devindra]

Hi,

I followed this code here, with slight modification to switch from csv to xlsx: https://documentation.sas.com/?docsetId=mcrolref&docsetTarget=n0ctmldxf23ixtn1kqsoh5bsgmg8.htm&docse...

which allowed me to import all the files in my directory into SAS.

What I would like to do now is to only import unique xlsx files moving forward, how would I go about doing this? 

[VDD]

create either a table, an array or something that can be IDed for the lookup and loop through your importing process.

[Devindra]

Sorry, how would I go about doing that?

[Tom]

What do you mean UNIQUE.  How can you have two different XLSX files with the same name?

[Devindra]

To import new files, and not files that have already been imported. One table would consist a list of files that were already imported. then a new table would populate a list of files currently in my directory, and then it would compare the two tables, and then import the files the new files that appear.

[SASKiwi]

One simple way to do this would be to move already-imported spreadsheets manually to an archive folder. Trying to do this automatically is a lot harder because then you have the problem of import failures and having to repeat imports.

[VDD]

this simple question (road block) @Devindra  is what we all have to deal with.  It is part of the requirements and development process that takes somewhere around 90-95% of our time before we start coding.

You did not explain what you fully needed with all of the details about the time series nor the comparing of data results over time.

please be as specific as possible in your needs, so that those replying have the details they need to understand the problem you are facing.