topic How do I import multiple excel files into SAS Enterprise Guide? in New SAS User

How do I import multiple excel files into SAS Enterprise Guide?

Keisuke_Uemura — Mon, 22 Jun 2020 11:36:10 GMT

There are some excel files in one folder.

The number of files is increasing.

These file names have a rule, like xx-0001,xx-0002,xx-0003.... xx-yyyy.

I want to import and combine spread sheets from all excel files.

I can import one by one, but files are many and increaseing sometimes. So I want to make a automation task to pass maintenance actions when files are increasing.

I want to combine by enterprise guide task, version 8.1.

Re: How do I import multiple excel files into SAS Enterprise Guide?

Reeza — Mon, 22 Jun 2020 15:51:20 GMT

How are you importing the files? Are they on your server or locally?
You can write a macro to loop through and import all quite easily but you need to provide more details.

Re: How do I import multiple excel files into SAS Enterprise Guide?

ballardw — Mon, 22 Jun 2020 17:56:29 GMT

What does "files are increasing" mean?

Approach would differ if "increasing" means "more records are added to existing files" compared to "new files are created".

Re: How do I import multiple excel files into SAS Enterprise Guide?

Keisuke_Uemura — Tue, 23 Jun 2020 10:08:06 GMT

Thank you for reply, and sorry, not inough to explane about problem.
"New files are created."

Re: How do I import multiple excel files into SAS Enterprise Guide?

Keisuke_Uemura — Tue, 23 Jun 2020 10:10:58 GMT

Thank you for reply.
Files are on server, in one folder.
I want to get solve by enterprise guide tasks, without writing macro for skillless users like me.

Re: How do I import multiple excel files into SAS Enterprise Guide?

Reeza — Tue, 23 Jun 2020 15:55:47 GMT

AFAIK there isn't a way to do this using tasks, this requires macros. I suppose you can create a parameterized process for one Excel file and then figure out how to call it for each Excel file.