SAS Enterprise Guide

Desktop productivity for business analysts and programmers
BookmarkSubscribeRSS Feed
JohnT
Quartz | Level 8

Gday,

I have lots of code I want to quickly move to Enterprise Guide. 

I like that several SAS jobs can be put onto a process flow and have links to each other.

A pit fall of this is that when I run a job which creates lots of datasets, the process flow window is cluttered and the links become very difficult to see. 

Is there a long term solution to this?

I have read that I could prefix all the datasets with _to (http://blogs.sas.com/sasdummy/index.php?/archives/248-Undocumented-features-theres-a-reason-they-are...) but this won't work forever and I wouldn't really want to prefix all my datasets.

Using PROC DATASETS and clearing the files isn't desirable from my point of view, I want to have those datasets there in case I've stuffed up somewhere.

Actually now that I think about it, there's an option to suppress the number of output datasets added to a project, am not sure yet if this will do what I want though. (doing this makes it tricky to perform a task on an output dataset).

Thanks.

4 REPLIES 4
Doc_Duke
Rhodochrosite | Level 12

The clutter is the price you pay for not using PROC DATASETS.  Mybe you could add the DATASETS after you are sure things are working.

TimCampbell
Quartz | Level 8

You could always put in the proc datasets step ready to delete all the datasets when you are happy with the process and put in a line at the start of your code   

     %let g_Debug=Cancel;

then have your proc datasets be something like   

     proc datasets lib=work nolist;       

          delete mytable;   

     run &g_debug;

this way while you are testing the tables will be left behind but when you change g_Debug to be blank then the datasets will get deleted.

also similar question at https://communities.sas.com/message/184224#184224

SASKiwi
PROC Star

I have found it useful to change the limit on the number of datasets to add to the Process Flow to 0 as suggested by Quentin in Tim's link above. All datasets are still created but they are not added to the Process Flow. You do get a warning saying the limit has been reached on every flow run, but I can live with that. I think this also helps improve EG performance because it reduces Process Flow maintenance.

JediApprentice
Pyrite | Level 9

@SASKiwi

I know this is an old post, but I am running into the same problem. How do you change the limit on the number of datasets to add to the Process Flow? 

sas-innovate-white.png

Special offer for SAS Communities members

Save $250 on SAS Innovate and get a free advance copy of the new SAS For Dummies book! Use the code "SASforDummies" to register. Don't miss out, May 6-9, in Orlando, Florida.

 

View the full agenda.

Register now!

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
  • 4 replies
  • 9650 views
  • 1 like
  • 5 in conversation