topic Re: Displaying Datasets in SAS Enterprise Guide

Displaying Datasets

cjohnson — Tue, 27 Oct 2009 14:14:23 GMT

I am working in Enterprise 4.1, SAS 9.1. I am rewriting a program to make it easier for coworkers to use. This program has about 30 data steps, some producing permanent datasets and some producing html output. Some are needed by the user, and some are only intermediate work. What I would like to do is have the user run the program, and then display certain output and datasets. Normally when you run a section of code, all outputs are displayed, and only the last dataset created is displayed. Is there a way to control this in the code?

Thanks,
Chris

Re: Displaying Datasets

Patrick — Wed, 28 Oct 2009 21:45:44 GMT

There is an option in SAS EG that it doesn't open DS and output automatically.

You also could programatically delete all the SAS DS which are only intermediary work DS.

Re: Displaying Datasets

RichardH_sas — Thu, 29 Oct 2009 14:08:23 GMT

Agreed with Patrick: I think (especially in EG 4.1) your only choices may be to turn off the automatic display of data sets and/or use PROC DATASETS or PROC SQL to delete some of the intermediary tables so they don't show up in the process flow. For example:

proc sql;
drop table work.test1, sasuser.query1;
quit;

In EG 4.2, there's a pop-up box to switch between output data sets from code or a task. That helps a little, but still isn't quite what you're asking for.