SAS® Enterprise Guide® shows only 500 tables within a library by default


By default, SAS Enterprise Guide displays only 500 tables within the Libraries window. In SAS Enterprise Guide, you see the message “Showing 500 of total-number data items,” as shown below. Next to this message, there are also More and All links that you can click to expand the list.

A screen in Enterprise Guide showing a list of data items and the message "Showing 500 of 801 data items" at the bottom

To increase the number of tables displayed within the Libraries window, you must add the MaximumChildrenToShowInTrees option within the <configuration> tags in the SEGuide.exe.config file. This file is located in the root installation directory of SAS Enterprise Guide (the default path is C:\Program Files\SASHome\SASEnterpriseGuide\8\).

Before you make any changes, create a backup of the SEGuide.exe.config file.

For example, the highlighted value in the configuration sets the option to display a maximum of 800 tables in the Libraries window.

     </Variables>
 </Environment>
 -->
 <!-- Example application settings -->
 <!--
 <appSettings>
   <add key="<key>" value="<value>" />
 </appSettings>
 -->
 <!-- Example application settings -->

   <appSettings>
      <add key="MaximumChildrenToShowInTrees" value="800"/>
   </appSettings>

 </configuration>

Note: To display all tables within a library without any limit on the number, set the value at 0 for the MaximumChildrenToShowInTrees option.

To set this option at deployment, see the Deploy a Custom Configuration File section in SAS® 9.4 Intelligence Platform: Desktop Application Administration Guide, Eighth Edition.