BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
BRKS
Quartz | Level 8

When multiple data steps / sorts are run at one time in SAS EG, it would be great if the default table displayed in the "Output Data" tab was the last one run.  Sometimes I run programs that create intermediate data sets that are used to produce the final data set.  When I click on the "Output Data" tab, 99% of the time I would like for the final data set to be displayed as the default.  And because I work with large datasets (millions of records), I have to wait each time I click for a new data table for it to load.  Seems like a small issue, but if this could be done, it would increase my day's efficiency and decrease my waiting time frustration.

 

Thanks for letting us make suggestions!!!

 

Barb

1 ACCEPTED SOLUTION

Accepted Solutions
8 REPLIES 8
SASKiwi
PROC Star

I'm in a similar situation in that I work with many large datasets. My solution is to set the number of datasets to open to 0. This means nothing gets written to the Output tab, but I can just open the one dataset I want from the Server List. I find this works efficiently for me 

BRKS
Quartz | Level 8
Thanks SASKiwi!

Nice solution. 🙂

I wasn't able to find the option to set the number of datasets to open to 0. Can you tell me where that is in the menus & submenus?

Thank you so much!
Barb
SASKiwi
PROC Star

Here is where you do it:

 

screenshot20.jpg

BRKS
Quartz | Level 8

Thank you so much!!!

CaseySmith
SAS Employee

We are going to try to handle this a little better in a future EG release by being a little more conservative about opening data -- or least providing one or more options to allow users to choose between the convenience versus the performance of automatically opening data.

 

Casey


Register today and join us virtually on June 16!
sasglobalforum.com | #SASGF

View now: on-demand content for SAS users

BRKS
Quartz | Level 8
Thanks so much, Casey! The setting that SASKiwi provided did exactly what I needed. But it is great that SAS is so open to its customers, and is continuously looking at how to improve performance! I love that about SAS!!
gusfryk01
Calcite | Level 5

Hi Casey, is there a solution to the original question?

I would also like to be able to see the last produced data set by default and I don´t see how the suggested solutions solve that. 

 

Henrik

CaseySmith
SAS Employee

Hi @gusfryk01,

 

No, there is not currently a solution for always showing the last produced data set by default (when multiple data sets are created by a program).  You can accomplish it though by naming the data set you wish to appear such that it is the last one alphabetically.

 

Setting the "Maximum number of output data sets to add to the project" option to 0 prevents EG from opening any output data sets, thus avoiding unintentionally opening potentially large (time-consuming) data sets.

 

Casey


Register today and join us virtually on June 16!
sasglobalforum.com | #SASGF

View now: on-demand content for SAS users

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

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
  • 8 replies
  • 3208 views
  • 7 likes
  • 4 in conversation