topic Exporting many files with enterprise guide in SAS Enterprise Guide

Exporting many files with enterprise guide

car — Mon, 17 Nov 2014 19:19:21 GMT

Hello,

I have to export 30 different files residing in SAS libraries in zOS to Excel spreadsheets in my computer.

PROC EXPORT doesn't work in this context, so I have to go through the tedious task of using the file/export option in Enterprise guide and, for every single file to export, do 5 clicks.

That is:

1- CHOOSE SAS library file to export

2- Define target format (Excel)

3- Select option to keep labels

4- Destination (Deep dive through my C: that is not retained for the next time)

5- Validate and GO!

It's a little bit painful.

Does someone know a shorter/clever way to do it?

It would be nice if I could reuse my first effort for the 29 pending exports to be done (changing only the files names).

Thanks a lot

Re: Exporting many files with enterprise guide

jakarman — Mon, 17 Nov 2014 19:36:27 GMT

- Using pcfiles server.

- Creating CSV files and do sftp

- using sas-base on pc-windows doing the conversion.

- having amo

There are enough short and clever ways. It is more the question why those are not supported / available

Re: Exporting many files with enterprise guide

Reeza — Mon, 17 Nov 2014 19:55:32 GMT

Here's an example of doing it with a custom add in. Basically do all the exports to your server then migrate the files to you C drive at once. Use a naming convention to help with the migration as you can use wild cards.

There and back again: copying files in SAS Enterprise Guide - The SAS Dummy

Export and download any file from SAS Enterprise Guide - The SAS Dummy

Re: Exporting many files with enterprise guide

JuanS_OCS — Mon, 17 Nov 2014 19:56:48 GMT

Jaap is right, you should check first if those options are available for you (ask your admin) and if not, maybe you can ask for the license more suitable for your needs.

Re: Exporting many files with enterprise guide

Kurt_Bremser — Tue, 18 Nov 2014 07:49:08 GMT

You have z/OS, so you have an IT department and scheduling.

Create SAS jobs that write .csv files (or use tagsets.excelxp to write .xml), have them run regularly by your DC people, and have them transfer the results to a network location where you can pick them up.

Re: Exporting many files with enterprise guide

car — Tue, 18 Nov 2014 19:12:50 GMT

Thanks to all of you.

I'll try Creating CSV files and do sftp option.

The other options:

- Copy Files task for SAS Enterprise Guide: Is quite attractive. However, unfortunately, I'm not allowed to install anything in PC if it hasn't been certified previously by platform responsible (Windows team in this case).

- Jobs and scheduling: It would make sense if this process had to be executed regularly, but this is not the case. It is a one-time effort.

Best Regards,

Re: Exporting many files with enterprise guide

Reeza — Tue, 18 Nov 2014 20:11:32 GMT

Add-In's aren't "installed" they just need to be placed in the correct folder, where EG is looking for them. As long as you have access it should be fine.

That being said, I've found that in my environment I don't have access

Re: Exporting many files with enterprise guide

jakarman — Tue, 18 Nov 2014 20:35:23 GMT

Reeza, add-ins and files that are copies can fall into a the "installed" software classification. The IT department likes to have copy deploy only applications.

The whole SDW approach of SAS not wanting to follow common processes is a nasty acceptation problem for IT alignment and cooperation.

I post and repeat that often, sorry for that. Just hoping for recognition and change.