topic Re: Ordered Lists - Create from Process Flow? in SAS Enterprise Guide

Ordered Lists - Create from Process Flow?

paulrockliffe — Tue, 16 Oct 2018 09:09:44 GMT

I have a process flow, it's quite complex with about 60 steps from start to finish. Some of the steps have the same names.

The first step is to import an Excel spreadsheet, which takes about 50% of the processing time. Then I run the process flow about 20 times, with different filters applied each time to give me different outputs.

I want to setup an Ordered List that I can run so that I can run the import once and then run everything else the 20 times through to save a load of time.

It's going to take a bit of messing around to create the list in the right order from the obvious selection menu because they're in alphabetical order and some have the same names.

Is there another way to create the Ordered List that would let me add everything, in the order it runs on my process flow, then I can just delete the first step to get what I'm after?

Thanks!

Re: Ordered Lists - Create from Process Flow?

tomrvincent — Thu, 18 Oct 2018 13:29:48 GMT

I'd suggest forgoing the list and simply use a macro loop to run 'everything else' 20 times.

Re: Ordered Lists - Create from Process Flow?

paulrockliffe — Thu, 18 Oct 2018 14:25:33 GMT

Thanks, that's an option, but I'd still need to manually create the order of processing, so it's not a quick thing to do.

Re: Ordered Lists - Create from Process Flow?

tomrvincent — Thu, 18 Oct 2018 15:14:40 GMT

Make each step a macro that can be called repeatedly with parameters (if globals aren't an option).