BookmarkSubscribeRSS Feed
paulrockliffe
Obsidian | Level 7

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!

3 REPLIES 3
tomrvincent
Rhodochrosite | Level 12
I'd suggest forgoing the list and simply use a macro loop to run 'everything else' 20 times.
paulrockliffe
Obsidian | Level 7

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.

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

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

Creating Custom Steps in SAS Studio

Check out this tutorial series to learn how to build your own steps in SAS Studio.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 1467 views
  • 0 likes
  • 2 in conversation