The refresh of the Libraries section in SAS Studio for Viya might occur more slowly than expected, depending on the following characteristics of the library definitions:

• how many library references are created through the LIBNAME statement
• whether the libraries are databases (which take more time to update)
• how many tables are in the libraries

An action that you can take to improve performance after code submission is to limit the libraries that are defined on start-up to only the libraries needed. You can create another SAS program with additional LIBNAME statements that you use infrequently and then run that when needed. 

In SAS^® Studio 4.4, the refresh of the Libraries section occurs automatically after every program submission.

In SAS^® Studio 5.1 and 5.2, you can control the refresh of the Libraries section through the use of the preference Automatically refresh libraries after each submission. This preference is found under the General preferences.

Click the Hot Fix tab in this note to access the hot fix for this issue.

The hot fix implements efficiencies in the code in all releases to reduce the time in which the refresh occurs.

In addition, the hot fix for SAS Studio 4.4 provides three new configuration properties, which, when used, can improve performance by disabling some actions in the user interface.

These properties are set to true by default. Therefore, if you do not add these new properties to the init_usermods.properties file, SAS Studio 4.4 works in the same way as it did before the update (but with improved performance in how the Libraries refresh occurs).

The new properties are as follows:

webdms.allowRefreshAfterSubmit=true|false

• When this property value is true, the Libraries section still refreshes after each code submission.
• When this property value is false, the Libraries section is not refreshed automatically after any action. To refresh the Libraries section, you must click the Refresh icon.

webdms.enableAutoComplete.libraries=true|false

• When this property value is true, the autocomplete feature works for library names as it did before this update, which is determined by your preference.
• When this property value is false, the autocomplete feature does not work for library names, regardless of user preference.

webdms.enableAutoComplete.tables=true|false

• When this property value is true, the autocomplete feature works for table names as it did before this update, which is determined by your preference.
• When this property value is false, the autocomplete feature does not work for table names, regardless of user preference.

Note: Do not use the combination of webdms.enableAutoComplete.libraries=false and webdms.enableAutoComplete.tables=true. This combination does not improve performance and might cause unexpected results.

Operating System and Release Information

Viya on Linux: An update for this issue is available for SAS Viya 3.4. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.4 for Linux Deployment Guide at

Viya on Windows: An update for this issue is available for SAS Viya 3.4. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.4 for Windows Deployment Guide at

Viya on Windows: An update for this issue is available for SAS Viya 3.5. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.5 for Windows Deployment Guide at

Viya on Linux: An update for this issue is available for SAS Viya 3.5. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.5 for Linux Deployment Guide at