Automatically open output when running query in project in SAS EG 8

[tdswart]

Hello,

Is there a way to make SAS EG 8 open the output of queries automatically as was done in SAS EG 7 when running projects? 

When I have a project with a query in it, and I press 'Run project', the resulting table would be opened automatically in SAS EG 7 in a new tab and the focus would be shifted to that tab automatically as well. When I do the same in SAS EG 8 the result of my query is not shown when running the project.

I thought there would be an option like in SAS EG 7 to disable or enable this. This option was found under Tools -> Options - > Results -> Results General "Automatically open data when generated" in SAS EG 7 but I can not find it in SAS EG 8. When going through the documentation on SAS EG 8 and its' new features I was also unable to find anything... 

Is there an option like this in SAS EG 8 and am I unable to find it? Or is it simply gone?

Thank you in advance for your help.

[PhilC]

try this

[tdswart]

Hello PhilC,

Thank you for your reply, but unfortunately this did not solve my issue. Even when I have the 'Output data' as default tab to display the resulting dataset from my query is not displayed in a new tab after I click 'Run project'. The dataset is visible in my project but I want SAS EG to open the resulting dataset automatically in a new tab and shift the focus to that tab as was done in SAS EG 7. For more context, here is an older question in which a user wanted to achieve the opposite of what I want in SAS EG 7:

https://communities.sas.com/t5/SAS-Enterprise-Guide/Output-Automatically-Opens/td-p/435900

If I am unclear please let me know. 

[SASKiwi]

SAS EG 8 creates an Output Data tab for each project or program run and creates a click-to-open icon with the dataset name for each dataset created. AFAIK there is no option to automatically open any of these. Most SAS projects / programs will product multiple datasets and the Output Data tab only allows you to open one dataset at a time. If there was an automatic "Open Dataset" option, which one should it open?

[tdswart]

Hey there SASKiwi,

In SAS EG 7 the last output object would be automatically opened when running a project. If I would have a project with 2 queries and a 1-way frequencies task as the last step in there it would open the results from the 1-way frequencies task automatically and shift focus to the tab. You would also automatically see the results in the same way when selecting a single task in a project and right clicking on it to run the task. 

You were able to change this behaviour under Tools > Options > Results > Results General > 'Automatically open data or results when generated'. When this was toggled off you would see no output, much like SAS EG 8 when either running the whole project or running a task separately. 

I would like to see the same behaviour in SAS EG 8: when I run a project or a single task by right clicking on it to run it I want to see the last output object generated automatically.

[jennifert]

Hi @tdswart ,

In SAS Enterprise Guide 8.2, there is the When output tables are generated, automatically open option under Data > Performance that might be what you are looking for.  You can choose to automatically open the last table, the first table, or no table the first time that output tables are generated.

The option is documented here:  Setting Data Performance Options.

I hope that helps!

thanks,

Jennifer

[tdswart]

Hey there jennifert,

Thanks for your response, but this has not resolved my issue. This option was already enabled in my SAS EG 8.3 instance. It seems that this option only opens your output data automatically when you open the task in the project and run it. When I right click the task in the process flow of my project and click run no tab is opened. There is also no tab opened when I simply run the whole project. 

In SAS EG 7, no matter how you ran the task, the output table of the last task would be opened automatically in a new tab and the focus would be shifted there. I want to replicate this behaviour in SAS EG 8.3.

[jennifert]

Hi @tdswart ,

Yes, I think this option applies only the first time that the output tables are generated.  I'll check with the development team to see if the behavior that you are looking for is available and post back here if I learn anything that could help.

thanks,

Jennifer

[SASKiwi]

@RPYee  - Did you read @jennifert 's response? There is an option for automatically opening the last created dataset in the link she provided.

Also open the EG process summary window and see what happens when you run your project. It will automatically show a green traffic light if it runs without error. It also shows the number of SAS notes, warnings and errors in your log.

[creid]

Was there ever any update on this? I have multiple novice users that find it frustrating that in the move from v7 to v8 this option is no longer available in the same way it was for v7 and none of the other solutions listed here are acceptable to my users.

[ballardw]

---

@creid wrote:

Was there ever any update on this? I have multiple novice users that find it frustrating that in the move from v7 to v8 this option is no longer available in the same way it was for v7 and none of the other solutions listed here are acceptable to my users.

---

I might suggest starting your own thread and reference this one.

Then describe exactly why the solutions mentioned are not acceptable to your users.

As an aside, I have found it somewhat entertaining that when EG was released that we had a number of requests on how to disable this automatic opening of output. Different strokes for different folks I guess.

[RPYee]

Have you had any luck solving this issue?  I just upgraded from SAS EG 7 to 8.  This is EXTREMELY frustrating! I have nothing to indicate that the program has finished running except that all the colors are gone from the icons.  With sometimes 20+ processes inside one program, this is really a pain point.  I want the final output to open up automatically after all of the program has run...

[bradmeadows]

Is there really no way to do this now?  I have been trying to figure this out for awhile.

I need EG to do "something" when it has completed the process.  I need a screen change of some sort just like it did in prior versions.

[SASKiwi]

@bradmeadows  - Open the Submission Status window in EG 8 (on the EG menu select View - Submission Status). This provides a list of all processes / programs that are running or have run in the current session. Does this meet your needs?

[carran084]

Hello everyone! About 6 months ago we migrated from SAS 7 to SAS 8, this behavior of SAS 8 gives us problems, we don't know when a process ends. We have complex processes that take time to execute and we have had to repeat them simply because we do not know if one is finished or not. Please SAS do something to fix it.