topic Re: How to import unique SAS files from a directory? in New SAS User

How to import unique SAS files from a directory?

Devindra — Fri, 18 Oct 2019 18:55:41 GMT

Hi,

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

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?

Re: How to import unique SAS files from a directory?

VDD — Fri, 18 Oct 2019 19:09:33 GMT

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

Re: How to import unique SAS files from a directory?

Devindra — Fri, 18 Oct 2019 20:04:09 GMT

Sorry, how would I go about doing that?

Re: How to import unique SAS files from a directory?

Tom — Fri, 18 Oct 2019 20:37:51 GMT

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

Re: How to import unique SAS files from a directory?

Devindra — Fri, 18 Oct 2019 20:47:54 GMT

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.

Re: How to import unique SAS files from a directory?

SASKiwi — Fri, 18 Oct 2019 22:24:59 GMT

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.

Re: How to import unique SAS files from a directory?

VDD — Fri, 18 Oct 2019 22:43:44 GMT

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.