Migrating SAS 9 Libraries to SAS Viya Compute Libraries

2 Likes

SAS Viya allows administrators to interactively define and manage Base SAS Libraries for the SAS Compute Server. The addition of this new feature was a pre-requisite required to support the migration of SAS 9 Base libraries to libraries in the Viya Compute Server. I described this functionality in detail in my last post. In this post, I will review the new migration functionality that supports the import of SAS 9 Libraries to Compute libraries in Viya.

SAS Viya Content Migration has always migrated Base SAS Libraries, but until now they have only been migrated to CAS Libraries in Viya. In 2022.1.3 support is added for the migration of libraries to CAS and/or Compute libraries.

This is a handy new addition to the migration toolset. While some of the content migrated from 9.4 like Visual Analytic Reports does require the data to be available in CAS, much of the content also requires data libraries to be available in the Compute Server. For example, Enterprise Guide Projects and Data Integration Studio Jobs are migrated to SAS Studio Flows, and Stored Process are migrated to Viya Jobs. Both Flows and Jobs use the Compute server and as result require SAS libraries to be available to compute in order to access data. Prior to the 2022.1.3 release, a Viya Administrator had to make the required libraries available by coding a libname statement in the Compute Server Autoexec as a manual step separate from the migration process.

Importing Libraries to Viya

To migrate libraries, in SAS 9.4 use SAS Management Console to export the library definitions to a package file. In Viya 2022.1.3 the Import User Interface in SAS Environment manager has been enhanced to support the creation of CAS and Compute libraries.

The default import settings create:

A CAS and Compute Library
The CAS library is on the default CAS server cas-shared-default
The Compute library is on both the SAS Studio and Job Execution Compute contexts

While these are the defaults, the user interface does allow you to map to additional CAS servers and Compute Contexts. In SAS Environment Manager during import, the Data Resources tab on the Mapping screen surfaces the new user interface.

Select any image to see a larger version.
Mobile users: To view the images, select the "Full" version at the bottom of the page.

At the end of the import process, the Result screen gives a detailed description of what has happened. The CAS library was created, and in addition, a Data Source representing the Compute library was defined and added to the two selected Compute Contexts.

As described in my previous post you can manage the new library in two locations in SAS Viya.

SAS Environment Manager

In SAS Environment Manager you can find the new library in the context definition. Select Contexts > Compute Context and edit the SAS Studio Compute Context. Select the Resources tab and you will see the Sales Data library is available.

SAS Studio

As a Viya Administrator in SAS Studio select the Libraries node in the explorer. Check the option to display disconnected libraries and you will see the Sales Data library.

The import result message stated that the library was added to the compute context, but the “library is not set for pre-assignment”.

In order for the Content to work the library needs to be assigned/connected so that is available to the SAS process when a compute session starts. To do this a Viya Administrator has a choice of the two interfaces, both approaches have the same impact.

In SAS Environment Manager, check the “assign” check box on the Resource in the Compute Context (shown above). In SAS Studio, select the Disconnected Library and edit the connection. Under “Allow all users to view the library connection” check the box “Add as connected”.

Now that the libraries are imported to both CAS and Compute, and set to be pre-assigned, the data will be available for use with the imported SAS 9 content.

Summary

To summarize, Viya Compute libraries can now be:

Defined in the Resources section of Viya Compute Contexts
Defined and Managed in SAS Studio
Assigned automatically when Compute sessions start.
Created when importing SAS package files that include SAS 9 path-based SAS libraries.

Here are some links to additional information and some related SAS 9.4 to Viya Migration content:

Find more articles from SAS Global Enablement and Learning here.