Have you ever waited a bit for SAS Enterprise Guide to display the Output Data tab when submitting a SAS program that generates multiple output tables? Or, perhaps your program only generates one big output table but it takes a little while for it to surface on the Output Data tab? You are in luck! There is an easy way to suppress the Output Data tab in the data grid window from opening up in your Enterprise Guide session after submitting a SAS program.
Here is a simple example of creating multiple output tables in one data step. Keep in mind the data set used as input in this example is very small in terms of the number of observations and variable so the Output Data tab would automatically open up very quickly. However, if your input data set is HUGE and your intention is to split it up into smaller SAS data sets, it could take a while to present all the new tables on the Output Data tab.
Here is your answer. Select Tools à Optionsà- Resultsà Results General and set the value of 'Maximum number of output data sets to add to the project' to 0.
As an added note, when this option is selected the output tables will NOT be added to the Process Flow. Below is a screenshot of what Process Flow would look like in this example after setting the option above. By default, we would have seen 3 output tables on the Process Flow – one for Acura, one for Audi and lastly, one for BMW. Also notice the ‘Data Set Limit Reached’ note is automatically added to the Process Flow as a result of choosing this option.
Now, on the other hand, let’s suppose you DID want to display the new table(s) in the data grid window after submitting a SAS program. There is a performance option which will limit the number of rows displayed in the data grid window. The default setting is one million rows but this number can simply be reduced. Select ToolsàOptionsàPerformance and change ‘Limit number of rows to:’ to a smaller number of your choice. Here the number has been reduced to 1000 rows to display in the data grid for each table.
Hopefully, these two options will shed some light on making your interactive programming processes run a wee bit faster!
Want to learn more SAS tips and tricks? Schedule your summer SAS training. Visit our learning paths, or find a course near you by location. If you’re looking for a particular course, search our A-Z course list, or narrow your search by software product. You can select the format that suits you best: classroom, Live Web or e-learning.