In this continuation of posts about SAS 9 Content Assessment reports, we look at the SAS 9 Profile for SAS Enterprise Guide Migration report and review what information it provides, what conclusions can be drawn, and what likely actions you would take after reviewing it. As a reminder, this series of posts does not cover how to run SAS Content Assessment applications. Instead, it focuses on using the results. For information about running the SAS Content Assessment, check out his post and this demo.     SAS Content Assessment Profile Application   The SAS Content Assessment Profile application provides detailed information about the attributes of SAS 9 content. Profile delivers reports for each SAS 9.4 content type. The reports include details like:   Tasks used in SAS Enterprise Guide projects Transformations used in SAS Data Integration Studio projects Users, groups, and group memberships Encoding of SAS data   The profile application and the various reports help you to understand the details of SAS 9 content and how those details impact migration to SAS Viya.     SAS 9 Profile for Enterprise Guide Projects Migration   The SAS 9 Profile for SAS Enterprise Guide Migration report covers SAS Enterprise Guide projects.   SAS Enterprise Guide projects are made up of tasks (the nodes in the projects). Projects migrate to SAS Studio flows, which include steps (the nodes in the SAS Studio flows). Each process flow within a SAS Enterprise Guide project migrates to a SAS Studio flow.   Select any image to see a larger version. Mobile users: To view the images, select the "Full" version at the bottom of the page.     The migration process attempts to migrate a task to an equivalent step or steps in SAS Studio. If a task cannot be migrated to equivalent step(s), it is often migrated to a SAS Program step in SAS Studio that includes SAS code to perform the function of the task. A task might not migrate to an equivalent step because there is no matching step in SAS Studio. A good example of this would be “Update Library Metadata” because there is no metadata server in SAS Viya.   The SAS 9 Profile for SAS Enterprise Guide Migration report helps you to understand what will happen to SAS Enterprise Guide projects and their tasks during the migration process from SAS 9 to SAS Viya.     What can we learn?   The Overview tab in the report provides a summary of the status of all projects in the deployment. Currently, there are 23 projects in the deployment, with 18 of them being considered “migration candidates.” A migration candidate is a SAS project that is highly likely to succeed when migrating to SAS Viya. The number of migration candidates is determined by counting the SAS Enterprise Guide projects that contain only tasks that will migrate to SAS Viya. If all tasks will migrate, the project is a migration candidate (more details below).       The Profiled Project Details tab documents the projects' locations, SAS Enterprise Guide versions, and creation and update dates.       The Project Migration Concerns tab identifies project-level issues in the scanned projects. These projects will migrate; however, there are some items in a project that are either currently not converted to a corresponding feature or that might need manual intervention once migration is complete. A list of the type of project-level concerns that may be surfaced is provided.       Select the Project Item Migration Details tab to see the detailed analysis for each project and each task in a project. This tab helps you understand what will happen to the tasks within a project when the project migrates to a SAS Studio flow. The report classifies a task as Ideal Fit, Partial Fit, Code Fit, No Fit, or Undetermined Fit. A task is considered:   Ideal Fit: The task’s migration is automatic. All features or functionality used are maintained. Partial Fit: The task’s migration is automatic. All features or functionality used are maintained. After migration, an attribute might need to be set or a relationship to another object might need to be verified. Code Fit: The task’s migration is automatic. Most features or functionality used are maintained using code in a SAS Program step. No Fit: The task cannot be migrated, and there is no planned feature replacement for it in SAS Viya. Undetermined Fit: The task was unable to be profiled or evaluated for migration status.   Tasks within a project that are profiled will fall into one of the categories mentioned above.       The Project Item Migration Details tab allows you to explore the details about the task migration. It allows you to select an individual project and explore what will happen to the specific tasks in it. Let us look at the Financial Master project.   On the Project Item Migration Details tab, we have selected Financial_Master_v4 (the project shown in the image at the start of this post).  The project is a migration candidate because all tasks are either ideal fit, partial fit, or code fit. Notice that the status of each task is listed, and for those tasks that are not ideal fit, a reason is provided in the Conversion Message column.       The Project Item Conversion Messages tab gives us a task-based view.  The table on the left of the page shows the most frequently used SAS Enterprise Guide tasks in the SAS 9 environment and the steps that they become in SAS Viya. In this report, Query was the most used task. The table to the right shows the most common conversion messages for these tasks. Notice that the Query tasks will migrate to Query steps in SAS Studio in 28 cases, but there are five cases where the task will migrate to a SAS Program step, and the reason is provided in the conversion message in the table.       Another key piece of information from this tab is the SAS Studio licenses that are required for the equivalent steps in SAS Viya.   The Overall Project Migration tab is where we can take the next step in the migration journey. The projects listed on this tab can be downloaded to a CSV file that will drive the migration process. The CSV file is used as input to the SAS Content Assessment Import EG Projects application that imports SAS Enterprise Guide projects on the file system to the SAS Viya 4 platform. The application will iterate through the CSV file, importing each SAS Enterprise Guide project.       What do we do with what we learned?   The SAS 9 Profile for SAS Enterprise Guide Migration report offers a detailed analysis of our SAS Enterprise Guide projects, highlighting project characteristics, task usage, and migration readiness. What can we do with this information?   Identify Licenses Needed in SAS Viya   SAS Studio is currently available with three licenses: SAS Studio, SAS Studio Analyst, and SAS Studio Engineer. By documenting the license required for the tasks, the SAS 9 Profile for SAS Enterprise Guide Migration report identifies what level of SAS Studio is needed to run the resulting SAS Studio flows.   Prioritize Projects for Migration   Using the report, you can prioritize the migration of projects in the environment that are classified as migration candidates. These projects should migrate easily, with minimal adjustments, and take full advantage of equivalent steps in SAS Studio. Similarly, you can identify high-risk or complex projects that might require additional effort.   Remediate Partial Fit and Code Fit Tasks   The report identifies tasks in projects classified as Partial Fit. These tasks require targeted remediation. The report’s conversion messages help identify specific issues. Remediation can happen in the source environment or in SAS Viya after the migration.   Evaluate No Fit and Undetermined Fit Tasks   Tasks labeled as No Fit or Undetermined Fit might require a redesign or alternative implementation strategies in SAS Viya. These tasks should be reviewed to determine whether functionality can be replicated using supported features in SAS Viya or if custom development is needed.   Automate Project Import with CSV Integration   The Overall Project Migration tab allows the export of the project list to a CSV file. The CSV file is used as input to the import EG projects application. This enables the automated import of selected projects, streamlining the migration process and reducing manual effort. Projects can also be imported individually with SAS Viya Environment Manager and the transfer plug-in of the SAS Viya CLI.     Wrap Up   The SAS 9 Profile for SAS Enterprise Guide Migration report helps assess the migration status of SAS Enterprise Guide projects. It analyzes each project and its tasks, identifying whether the projects are candidates for migration to SAS Studio flows. The report classifies tasks into categories (Ideal Fit, Partial Fit, Code Fit, No Fit, or Undetermined Fit) and classifies projects as migration candidates or not. It highlights licensing needs for SAS Studio and supports migration planning by generating a list of projects ready for migration.   The report helps to plan and execute the migration of SAS Enterprise Guide projects to SAS Studio flows on SAS Viya. It helps identify the appropriate SAS Studio license needed based on task requirements, it prioritizes projects that are ready for migration, and it flags projects needing remediation or redesign. The information in the report can be used to identify the usage of projects, which can lead to cleaning up projects before migration.   Here are some related resources, including the other posts in this series:   Communities Post: SAS 9 Content Assessment: the Profile Report for SAS Data Integration Studio Jobs (Update) Blog: Have You Heard of the Picture Superiority Effect? If Not, You’re About To! Communities Post: SAS 9 Content Assessment: Code Check Communities Post: SAS 9 Content Assessment: Application Usage Communities Post: SAS 9 Content Assessment: Inventory Communities Post: SAS Content Assessment Proven Practice SAS Demo | Using the modifySASCode Content Assessment Application – YouTube Communities Post: Content Assessment: SAS 9 Code Check for Internationalization Class: Migrating SAS 9.4 Content to the SAS Viya Platform on learn.sas.com Content Assessment Download SAS 9.4 to Viya Content Migration Documentation SAS Demo  | SAS Content Assessment Overview Communities Post: Migrating from SAS 9 to Viya: what's the first step  Communities Post: Migration of Stored processes to SAS Viya Jobs Communities Post: Content Assessment delivers utility applications to support SAS Viya Content Migration Communities Post: Go with the flow; migrating Enterprise Guide Projects to SAS Studio Flows Communities Post: SAS Viya 2021.2 – Migrating SAS Data Integration (DI) Studio Jobs to SAS Studio Flows Communities Post: A first look at Migration from SAS 9.4 to Viya 4 SAS Demo | SAS Viya Migration of Enterprise Guide Project to SAS Studio Flows – YouTube SAS Demo | Migrating SAS Data Integration Studio Jobs to SAS Studio Flows     Find more articles from SAS Global Enablement and Learning here. ... View more

In this continuation of the series of posts on the SAS 9 Content Assessment reports, we look at the SAS 9 Profile for SAS Data Integration Jobs report and review what information it provides, what conclusions can be drawn from it, and what likely actions you would take after reviewing it.   As a reminder, this series of posts does not cover how to run SAS Content Assessment applications; instead, it focuses on using the results. For information about running the SAS Content Assessment, check out this post and this demo.     SAS Content Assessment Profile Application   The SAS Content Assessment Profile application provides detailed information on the attributes of SAS 9 content. Profile delivers a series of reports for each SAS 9.4 content type. The reports include details like:   Tasks used in Enterprise Guide projects Transformations used in Data Integration Studio Jobs SAS Code locations and use of prompts in Stored Processes Encoding of SAS Data   The Content Assessment Profile application and reports help you to understand the details of SAS 9 Content and how those details impact migration to SAS Viya.   The SAS Profile for Data Integration Jobs report is the main report covering SAS Data Integration Studio Jobs.   SAS 9 Data Integration Studio jobs consist of transformations (the nodes in the jobs). Jobs migrate to SAS Studio flows, which include steps (the nodes in the SAS Studio flows).   Select any image to see a larger version. Mobile users: To view the images, select the "Full" version at the bottom of the page.   The migration process will attempt to migrate a transformation to an equivalent step or steps in Studio. If a transformation cannot be migrated to equivalent step(s), it is often migrated to a SAS Studio Program step that includes SAS code to perform the function of the transformation. A transformation may be prevented from migrating to an equivalent step because there is no matching step in Studio, or some attribute of the transformation is not yet supported. The SAS 9 Profile for SAS Data Integration report helps you to understand what may happen to the SAS Data Integration Studio Jobs and their transformations during the migration process from SAS 9 to SAS Viya.     What can we learn?   The SAS Data Integration Studio report will analyze each SAS Data Integration Studio job and classify each job and each transformation within a job.   The Overview tab in the report summarizes the status of all the Jobs and Transformations in the deployment. In this deployment, there are 27 jobs with 53 Transformations. Of the 27 jobs, 24 are “Migration Candidates.” A migration candidate is a SAS object believed to have a high probability of success when migrating to SAS Viya. For SAS Jobs, there are varying degrees of success based on whether there is migration support for some or all of the transformations used in the job. The Overview tab also provides details of when Jobs and Transformations were created and last updated.     The Jobs tab provides details about the characteristics of the jobs in the environment, including:   transformations per job whether jobs have pre-code and post-code whether the jobs have been deployed for scheduling     The Transform Usage tab and the Jobs Using Transforms tab both focus on how many of each type of transformation is used and where they are used. The Transform Usage tab provides counts of the SAS Data Integration Studio transforms used in the jobs and whether those transformations have user-written code. Jobs Using Transforms lists the transformations for each job and whether they have user-written code.   The Data Usage tab documents the data used by the SAS Data Integration Jobs. Data is classified as:   Persisted Tables: library-based data sets that persist after the SAS session closes Transient Tables: tables that typically use the SAS Work library are deleted when the SAS session closes External Files: files that are read from the file system.   You can identify what tables are used in each job and whether they are source or target tables.     Transformation Migration Details is a key tab on the report. This page helps you understand what will happen to the transformations within a Job when the job migrates to a SAS Studio Flow. The report classifies transformation as Ideal Fit, Partial Code Fit, No Fit, or Undetermined Fit. A transformation is considered:   Ideal Fit: The migration of the transform is automatic. All features or functionality used are maintained. Partial Fit: The transform's migration is automatic. All features or functionality used are maintained. After migration, an attribute might need to be set, or a relationship to another object might need to be verified. Code Fit: The transform's migration is automatic. Most features or functionality are maintained using code in a Studio Program Step. No Fit: The transform cannot be migrated, and there is no planned feature replacement for it in SAS Viya. Undetermined Fit: if the transformation was unable to be profiled or evaluated for migration status.   Transformations within a Data Integration job that are profiled will fall into one of the categories mentioned above.     The Transformation Migration Details page allows you to explore the details of the transformation migration. It also allows you to select individual jobs and explore what will happen to the specific transformation in them. Let us look at a couple of jobs.   Ideal Fit Job: 01_Split_Finance_Data   On the Transformation Migration Details tab, we have selected 01_Split_Finance_Data (the job shown in the image at the start of this post). All of the transformations in the job migrate to an equivalent step in SAS Studio. The report shows the:   File Writer Transformations will migrate to an Export step in SAS Studio Extract Transformation will migrate to a Query step Splitter Transformation will migrate to a Branch Rows step.     This job is ready to migrate to SAS Viya and SAS. Studio.   Partial Fit: Supplier Load   On the Transformation Migration Details tab, we have selected Supplier Load. This job has two transformations one is ideal fit and one is partial fit. The partial fit transform is a SCD Type 2 loader in SAS Data Integration Studio. While it will migrate to an equivalent step in SAS Studio, as the conversion message indicates it may need some modifications to get it running.     Instead of approaching what will happen from the job perspective, Transform Migration Conversion Messages gives us a transformation-based view. The table on the left of the page shows the most frequently used SAS 9 transformations in the SAS 9 environment and the Steps they become in SAS Viya. In this report, the File Reader was the most frequently used transformation, and we can see that it will be migrated to a SAS Program Step. The table to the right shows the most common conversion method for these transformations.     Another key piece of information from this tab is the SAS Viya Studio licenses required for the equivalent steps in SAS Viya.   The Job Migration tab is where we can take the next step in the migration journey. Jobs are classified as migration candidates based on the percentage of transformations in the job that are an ideal fit.     The Job listing in this tab can be downloaded to a CSV file that will drive the migration process.   The CSV file is used as an input to the SAS Content Assessment CreateSASPackages application, which will automate the export of the SAS Data Integration Studio jobs that you select for migration. You can use the slider to investigate the impact of lowering the threshold for the "percentage of transforms with ideal fit". When you adjust the slider, Jobs higher than the ideal fit threshold are color-coded blue in the table listing. The buttons can be used to filter the jobs in the table, and the checkboxes can be used to select group(s) of jobs to export for package creation.       What do we do with what we learned?   The SAS 9 Profile for Data Integration report offers a detailed analysis of our SAS 9 Data Integration environment, highlighting job characteristics, transformation usage, and migration readiness. What can we do with this information?     Identify License Needed in SAS Viya   SAS Studio is currently available with three licenses. SAS Studio, SAS Studio Analyst, and SAS Studio Engineer. By documenting the license required for the transformations, the report will identify what level of SAS Studio is needed to run the resulting SAS Studio flows.     Prioritize Jobs for Migration   Using the report, you can prioritize the migration of jobs in the environment that are classified as migration candidates. These jobs should migrate easily, with minimal adjustments, and take full advantage of equivalent steps in SAS Studio. The reports also identify which jobs are being used and the frequency with which the jobs are changing. This information is used with other Content Assessment reporting and can help to develop a strategic plan for the migration of Data Integration jobs.     Remediate Partial Fit Transformations   The report identifies transformations within jobs classified as "Partial Fit." These transformations require targeted remediation. The report’s conversion messages help identify specific issues. Remediation can happen in the source environment or can be addressed in SAS Viya after the migration.     Evaluate No Fit and Undetermined Fit Transformations   Transformations labeled as No Fit or Undetermined Fit might require redesign or alternative implementation strategies in SAS Viya. These transformations should be reviewed to determine whether functionality can be replicated using supported features in SAS Viya or if custom development is needed.     Automate Job Export with CSV Integration   The Job Migration tab allows export of job listings to a CSV file. The CSV file is used as input to the createSASpackages application. This enables automated packaging of selected  SAS Data Integration Studio jobs, streamlining the migration process and reducing manual effort.     Identify Key Data and its Location   The Data Usage section of the Data Integration Studio report reveals which datasets are actively used across jobs, including persisted tables, transient (temporary) tables, and external files. This enables us to identify critical data assets for migration. We can plan for the migration of the data so that it is available in SAS Viya for the SAS Studio Flows that are created during the migration. The report can also be used to flag unused or redundant data for potential cleanup.     Wrap Up   The SAS 9 Profile for SAS Data Integration report helps assess the migration status of  SAS Data Integration Studio jobs. It analyzes each job and its transformations, identifying whether the jobs are candidates for migration to SAS Studio flows. The report classifies transformations into categories (Ideal Fit, Partial Fit, Code Fit, No Fit, or Undetermined Fit) and provides detailed insights about job characteristics, data usage, and transformation frequency. It highlights licensing needs for SAS Studio and supports migration planning by generating a list of jobs ready for migration.   The report helps to plan and execute the migration of SAS Data Integration Studio jobs to SAS Studio flows on SAS Viya. It helps identify the appropriate SAS Studio license needed based on transformation requirements, it prioritizes jobs that are ready for migration, and it flags jobs needing remediation or redesign. The information in the report can be used to identify the usage of jobs, which can lead to cleaning up jobs before a migration.   The report supports creating a CSV file of candidate jobs that can be used with the createSASpackages application.   Here are some related resources, including the other posts in this series:   BLOG: Have You Heard of the Picture Superiority Effect? If Not, You’re About To! Communities Post: SAS 9 Content Assessment: Code Check Communities Post: SAS 9 Content Assessment: Application Usage Communities Post: SAS 9 Content Assessment: Inventory Communities Post: SAS Content Assessment Proven Practice SAS Demo | Using the modifySASCode Content Assessment Application – YouTube Communities Post: Content Assessment: SAS 9 Code Check for Internationalization CLASS: Migrating SAS 9.4 Content to the SAS Viya Platform on learn.sas.com Content Assessment Download SAS 9.4 to Viya Content Migration Documentation SAS DEMO  | SAS Content Assessment Overview Communities Post: Migrating from SAS 9 to Viya: What's the first step Communities Post: Migration of Stored Processes to Jobs Communities Post: Content Assessment delivers utility applications to support SAS Viya Content Migration Communities Post: Go with the flow; migrating Enterprise Guide Projects to SAS Studio Flows Communities Post: SAS Viya 2021.2 – Migrating SAS Data Integration (DI) Studio Jobs to SAS Studio Flows Community Post: A first look at Migration from SAS 9.4 to Viya 4 SAS DEMO | SAS Viya Migration of Enterprise Guide Project to SAS Studio Flows – YouTube SAS DEMO | Migrating SAS Data Integration Studio Jobs to SAS Studio Flows     Find more articles from SAS Global Enablement and Learning here. ... View more

Recently, SAS introduced a new System Evaluation application for Viya 3.5 environments. This application enables organizations to assess the health of their systems and prepare for updates, upgrades and migrations to SAS Viya 4. In this post, we will look at how to install and use the application and what information the evaluation results provide.   System Evaluation is performed using the “Plan and Backup Ansible playbook.” This playbook is used in the planning stage of a migration to Viya 4 to scan and backup a Viya 3.5 deployment. The playbooks’ functionality has been enhanced to add evaluation capabilities.     Installation   The Plan and Backup Ansible playbook is delivered by the inventory plugin of the SAS-admin CLI. The inventory plug-in generates the playbook.   To get started, as the same user who will run the Plan and Backup Ansible playbook, download the latest sas-admin CLI from support.sas.com. You must also download the most recent version of the inventory, CAS, and backup plug-ins. The plugins are installed or updated using the sas-admin plugins command. The minimum version of the plugins required to perform the evaluation can change. At the time of writing, the minimum version is:   inventory 1.10.20 or higher cas 1.12.10 or higher backup 1.6.3 or higher   The command below will generate the playbook.   ./sas-admin inventory generate-playbook --output-location /tmp/inventory-playbook   To use the playbook, copy the files from the directory where it was created into the Viya 3.5 project directory. This is where the inventory.ini file and the install playbook files for the SAS Viya 3.5 environment are located.   To configure the scan and backup, set the variables in viya_plan_backup_vars.yaml. ​Some of the key variables in the vars file   endpointServer: which is the URL of the SAS Viya 3 server inventoryResultsLocation: the location to store the inventory results files evaluationResultsLocation: the location to store the evaluation results files reportCASServer : the CAS server where the result data will be loaded SAS_BACKUP_ID: an ID for the SAS Viya 3.x migration package (must be unique for each run) migrationPackageLocation: the storage location for the SAS Viya 3.x migration package.   All variables in the file are commented with the details of how to use them.​       Running the evaluate play​   To run the playbook, use the inventory.ini file that was used to deploy the SAS Viya 3.5 environment. The inventory.ini file defines the inventory of machines (hosts) and their roles in the Viya deployment. It tells Ansible which machines to configure and how to configure them. The playbook, by default, will perform both an inventory scan and backup if no parameters are provided. It accepts two parameters (tags) that will change that behavior:   evaluate inventoryscan   Each parameter is independent, it is recommended to run “evaluate” first. To run the play, change the directory to the directory that contains your inventory.ini file and run the viya-plan-backup.yml playbook passing the tag evaluate.   cd sas_viya_playbook/ ansible-playbook viya-plan-backup.yml --tags 'evaluate'     The playbook loads the data containing the evaluation results to the CAS server specified in the viya_plan_backup_vars.yaml file. The playbook also delivers the reports, and they can be imported to SAS Viya using the transfer plugin of the SAS Viya CLI or SAS Environment Manager.     System Evaluation Report   The SAS Viya 3.5 System Evaluation report contains four sections:   Migration Status System Status Installed Software About this Report   From a migration perspective, the most important section is Migration Status. This section assesses the eligibility of the Viya 3.5 environment for migration to SAS Viya 4. In the Migration Status section, the “Release Meets Migration Requirements” column is used to determine if you are eligible to migrate to SAS Viya 4. The report notes, “In order to use the full-system migration method to migrate to SAS Viya 4, your installation must be SAS Viya 3.5, released on October 29, 2024, or later.”  In our case, we can see that we are not eligible to migrate because the SPRE Build Date used to determine eligibility is 2019/11/06. The environment would need to be updated before it could be migrated to SAS Viya 4.     SAS recommends that you migrate to the latest SAS Viya 4 stable or LTS release.   If your environment is not eligible for migration, you will need to move to a release of Viya 3.5 released after October 29, 2024. If you are on a release prior to SAS Viya 3.5, you will need to follow the steps here to upgrade to the latest release. If you are on an earlier release of SAS Viya 3.5, use the steps here to update your 3.5 environment.   In the other sections of the report, System Status shows the characteristics of each host, including CPU, OS, and memory and shows the PostgreSQL version installed with SAS Viya 3.x. This information can be used to determine if the system supports upgrading to the latest release of Viya 3.5, and what resources may be required in a Viya 4 environment to support the migration.       Installed Software lists the versions of the RPMs installed in each server in the Viya 3.x environment.         Wrap Up   SAS has enhanced its Plan and Backup Ansible playbook for Viya 3.5 to include a system evaluation feature. This tool helps organizations assess whether their current environment is ready to migrate to SAS Viya 4. After using the sas-admin CLI inventory plug-in to create it, users can run the SAS Viya Plan and Backup playbook to generate a report that evaluates system health, software versions, and migration eligibility. If the environment meets the requirements, you can proceed with migration planning by running the inventory play of the playbook and ultimately creating a migration package. Otherwise, the report provides guidance on necessary updates.     Additional Resources   SAS® Viya® Platform: Full-System Migration from SAS® Viya® 3.x SAS Demo | Migration to SAS Viya: Assess and Package the Source 3.x System Keeping the SAS Administration Command-Line interfaces up-to-date     Find more articles from SAS Global Enablement and Learning here. ... View more

A SAS Viya Administration question that I have heard multiple times recently is whether it is possible to perform a partial backup and restore of a SAS Viya environment. In addition to hearing it from colleagues and customers, I also ran into a case where we needed to implement a partial backup in our internal reporting environment. Given the interest, I thought Communities post. 🙂   The SAS Viya Backup and Restore application employs a comprehensive approach to system backup and restoration. It generates a full backup of your Viya system, enabling you to restore the entire backup in the event of an issue or for disaster recovery and migration purposes. This feature provides assurance that your system is fully safeguarded and can be restored from the backup.   However, it is important to note that the restore process is designed to restore the complete Viya backup package, rather than individual components. Consequently, the restoration process may take time and may necessitate temporary system downtime.   What if you want to protect key Viya content and be able to restore that content selectively? Using SAS Viya's transfer service, you can back up only specific assets rather than the entire system, and in return, you can selectively back up individual or groups of content items without any impact on the running environment.     Why use this method?   Granular control: backup and restore only what you need. Efficient: backup only content that has changed in a certain time frame. No downtime: Doesn’t require stopping services or system access.   A limitation of this approach is that the user must keep track of dependencies and ensure that dependent objects, such as data used in reports, are also exported.     How do we do it: sas-viya transfer?   You can export the content to a SAS Viya package to backup specific items like reports, models, flows, jobs etc. The export can be performed interactively, but it is most useful to script the process for backup purposes. When the process is scripted it can be run on a schedule. The transfer plugin of the sas-viya CLI can be used to export content from the command line. You can export a folder and its content or individual content items.   Automating the export process takes a few steps, is dependent on a third-party tool, JQ, and requires identifying the Uniform Resource Identifier(URI) of the content to export. A URI uniquely identifies each folder and content item in SAS Viya. The example below shows the export of a single SAS Viya folder.   Identify the URI (a unique identifier) of the folder Export the folder by passing the URI to the sas-viya transfer export Identify the package ID of the package created. Download from the Infrastructure Data Server the package created as a JSON file.   folderid=$(sas-viya --output json folders show --path /gelcontent/GELCorp/Sales | jq | jq -r '.["id"]') sas-viya --output text transfer export -u /folders/folders/$folderid --name SalesContent$folderid packageid=$(sas-viya --output json transfer list --name SalesContent$folderid | jq | jq -r '.items[]["id"]') sas-viya transfer download -f /tmp/viya4packages/SalesContent.json --id $packageid   With this approach, we can script the backup of SAS Viya content to JSON package files and selectively restore content.     How do we do it: pyviyatools?   The pyviyatools are command-line tools that call the SAS Viya REST API from Python. They are available on the SAS GitHub site and include several tools for backing up and restoring SAS Viya content. Let’s look at some tools for partially backing SAS Viya content. Any of these tools can be scheduled to perform a partial backup regularly.   To export the same folder shown in the example above, we can use exportfolder.py. This tool accepts the full folder path as a parameter, removing some of the complexity of exporting a folder with the sas-viya CLI.   exportfolder.py -f "/gelcontent/GELCorp/Sales/Reports" -d /tmp/viya4packages --filename SalesContent.json -q   The package with the ID 2080ab30-12a0-41cc-91f8-b748f5c5c4a9 was created. /usr/local/bin/sas-viya transfer download --file /tmp/viya4packages/SalesContent.json.json --id 2080ab30-12a0-41cc-91f8-b748f5c5c4a9 NOTE: Viya folder /gelcontent/GELCorp/Sales/Reports exported to json file /tmp/viya4packages/SalesContent.json.json   If you want a backup of all your content, exportfoldertree.py will export the complete Viya folder tree. Each subfolder at the root of the folder tree is exported to its own SAS Viya package.   exportfoldertree.py -d /tmp/allfolders -q   Select any image to see a larger version. Mobile users: To view the images, select the "Full" version at the bottom of the page.   These two tools allow us to back up folders in the SAS Viya folder tree. Since each folder is exported to its own package file, individual folders can be restored. What if we want to get down to the individaul content level and only backup content that has changed. The Snapshotcontent.py tool allows you to pass a Viya folder. It will recurse through the folder and subfolders and export each content item to a JSON package. The user can filter by date so that only content changed in a specific time period is exported. The following command will export all content under the /gelcontent folder. Each content item will be exported to its own JSON package.   python snapshotcontent.py -d /tmp/snapshot_all -f /gelcontent -q   The JSON packages are named for the full folder path and item name, enabling easy identification of individual items to restore.     Adding the -c parameter allows the user to select only content that has changed in the chosen number of days. This makes it easy to only backup specific content items that have changed. The command below will export any content under the /gelcontent folder that has changed in the last day.   python snapshotcontent.py -d /tmp/snapshot_all -f /gelcontent -q -c 1   Snapshot content can be scheduled to run on a daily basis creating a partial and incremental backup of SAS Viya Content.   NOTE: An earlier tool snapshotreports.py does the same for SAS Visual Analytics reports.     Restoring/Importing   On the restore side we have choices to import/restore any of the content from the JSON packages.   Using SAS Environment Manager to import the content, you can select what content is restored from each package.     There are two steps to import with the SAS-Viya CLI. Firstly, upload the JSON package to SAS Viya, capturing the package ID, then pass the package ID to the import command to import the package.   packageid=$(sas-viya --output json transfer upload --file /tmp/viya4packages/SalesContent.json | jq | jq -r '.["id"]') sas-viya --output text transfer import --id $packageid   The pyviyatools also has a tool that can help with importing. Importpackages.py will loop through all the packages in a directory and import them to SAS Viya.   importpackages.py -d /tmp/snapshot_today/ -q   There are few related pyviyatools that can also help with export and import of Viya artifacts. The names explain what they do.   exportcaslibs.py exportgeoproviders.py exportcustomgroups.py exportstudioflowcode.py importcaslibs.py importconfguration.py     Wrap Up   In summary, the SAS Viya Backup and Restore application provides a full-system backup approach,  however selective backup and restore of SAS Viya content can be achieved using alternative methods. The SAS Viya transfer service and pyviyatools offer granular control, efficiency, and minimal downtime, allowing users to selectively backup and restore individual content items or folders. By leveraging automation and scripting tools like sas-viya CLI and pyviyatools, organizations can implement an efficient, tailored partial backup strategy for SAS Viya environments. This strategy should be implemented to compliment but not replace SAS Viya Backup and Restore.     Additional Resources   SAS® Viya® Platform: Using the Command-Line Interface pyviyatools You CAN take it with you! Saving SAS Viya Content     Find more articles from SAS Global Enablement and Learning here. ... View more

The SAS Content Assessment for PC Users is designed to evaluate and manage SAS content, specifically on Windows and Linux PCs. It focuses on identifying, cataloging and analyzing SAS content and assisting with migration planning. It is specifically aimed at SAS environments where users store their content, like SAS programs or Enterprise Guide Projects on a PC. It is a related tool to SAS 9 Content Assessment. SAS 9 Content Assessment Tool is a broader tool for assessing SAS 9 environments that include a metadata server. Let’s examine the SAS Content Assessment for PC users.   SAS 9 Content Assessment for PC Users   SAS 9 Content Assessment for PC Users is designed to be very easy to run so that individual SAS users can assess their own content. To run the application, there are four simple steps:   Select any image to see a larger version. Mobile users: To view the images, select the "Full" version at the bottom of the page.   NOTE: An administrator can also run the application against SAS content on a server or stored on shared storage.   Download   SAS Content Assessment for PC users can be downloaded from the SAS 9 Content Assessment Page at support.sas.com . The download links are at the bottom of the table and are the files that include “for PC Users” in the name. There are two downloads of SAS 9 Content Assessment for PC Users, one for Linux and one for Windows. They work in the same way. In this post, we will focus on the Windows version     Install and Configure   After downloading the file, users should unzip it to their PC. At that point, they are ready to configure the application. Configuring the application is simple. Edit the setup.txt file located in the assessment directory. There are three variables to edit.   SAS_HOME: is the primary location where the SAS products are installed. PATH: is a series of paths that the application should scan. In the example, we use one path. LABEL: is a unique label for the scan.     Run   After installing and configuring the tool, running it is straightforward. Double-click on the executable runme.bat. The application will open in a window, sending messages to that window as it runs each step. When it is complete, the application will describe where you can find the results.     What does it do?   SAS Content Assessment for PC Users includes three content assessment planning applications. They all execute when the user clicks on the runme.bat executable. The applications perform the same functions that they do in the full-blown Content Assessment:   inventory: documents the nature and volume of SAS content. In this case, it is SAS content stored on the file system. gatherSAScode: generates and stores SAS code from Enterprise Guide projects and SAS Catalogs to support code checking the application codeCheck: checks and documents the suitability of SAS 9 code for migration to SAS Viya   In addition, a utility application, publishAssessedContent, is run. This application creates the data mart and the reports.   What will a user learn?   Two HTML reports are created in the assessment directory surfacing the inventory and codecheck results.   Let’s first examine the inventory report, which has two subreports: artifacts and licensed products. Artifacts is the SAS content inventory created by scanning the the paths listed in the setup.txt file for SAS content. At the top of the artifacts page is a summary table with a count of each SAS 9 artifact found. This table gives a good idea of the nature and volume of content for this user.     Below the summary table, there’s a table for each artifact. It details the artifact’s location, size, and last modification date. This table serves as your inventory of what the tool has discovered. The summary table indicated that the user has 21 Enterprise Guide projects. Below is the table for Enterprise Guide Projects documenting their location and when they were last modified and accessed.     SAS 9 Code Check examines SAS programs to determine compatibility with SAS Viya. It examines SAS 9 code stored in program files on the file system and SAS code gathered from SAS artifacts by the gatherSAScode application. The SAS Code check will check the code for the following:   Syntax elements that are not supported in SAS Viya 4 Syntax elements that might have processing restrictions in SAS Viya 4 Hard-coded physical paths.   The code check application creates a series of reports covering a specific aspect of the code that may influence whether it can run on SAS Viya.     SAS Procedures document the SAS procedures used in the SAS programs scanned. The Libname, filename, infile statements and hard-coded paths  reports all document where the programs access the file system. This location may change in SAS Viya.   “SAS Programs That Are Incompatible” documents where SAS elements in the code will not run in SAS Viya, and “SAS Programs With Statements That Need Attention” documents SAS elements that may be restricted by default in SAS Viya.     What can a user do with the results?   The inventory results will give users an idea of the scale of their migration efforts by documenting all the SAS content on their PCs. In addition, the inventory can identify regularly used artifacts that are a priority to migrate and artifacts that are no longer used and can be deleted or archived.   SAS 9 Code Check will check a user’s SAS programs and Enterprise Guide projects to determine their compatibility with SAS Viya. A. It checks for syntax elements not supported in SAS Viya 4, syntax elements that might have processing restrictions in SAS Viya 4 and hard-coded physical paths. The code flagged as incompatible must be rewritten for use in SAS Viya. Code with processing restrictions may be a little easier to deal with. Some elements can potentially be replaced with other, more secure techniques. The report also flagged hard-coded file system paths, which, in many cases, may need to change in SAS Viya.  For an individual user, The report can be used to identify the level of effort required to migrate their SAS 9 Code to SAS Viya.   Summary   The SAS Content Assessment for PC Users is tailored for individual PC environments. In contrast, the SAS 9 Content Assessment Tool is designed to comprehensively evaluate server-based SAS 9 environments. Using the SAS Content Assessment for PC users, individual users with SAS content stored on their machine or in a location their machine accesses can get a feel for how easy it would be to transition to SAS Viya. They can use the results themselves or share them with a SAS Administrator as part of an overall migration project.   Additional Resources:   SAS 9 Content for Windows PC Users Documentation SAS 9 Content for Linux PC Users Documentation YOUTUBE Demo: SAS 9 Content Assessment for PC Users     Find more articles from SAS Global Enablement and Learning here. ... View more

Continuing the series of posts on the SAS 9 Content Assessment reports, we review the SAS 9 Code Check report to see what information it provides, what conclusions can be drawn from it, and what likely actions you would take after reviewing it. As a reminder, this series of posts does not cover how to run SAS Content Assessment applications; instead, it focuses on using the results. Check out this post and demo for information about running the SAS Content Assessment.   SAS 9 Content Assessment Code Check   SAS 9 Code Check examines SAS programs to determine compatibility with SAS Viya. It examines SAS 9 code stored in program files on the file system. The SAS Code check will check the code for the following:   Syntax elements that are not supported in SAS Viya 4 Syntax elements that might have processing restrictions in SAS Viya 4 Hard-coded physical paths.   Before we examine what we can learn and what we can do with what we learn, let’s see how the code is checked. In the SAS 9 environment, we have SAS code in programs that reside on the file system in a directory "d:\\workshop\\gelcorp" and SAS code in SAS artifacts like Enterprise Guide projects, Stored Processes and Data Integration  Jobs. We want to check all of this code. For the programs on the file system, we can run code check directly against the directory where the files are stored, and all files with a .sas extension in the directory or any sub-directories will be checked. The scan tag is used to tag the data from this scan, and the tag can be used to subset the data on the report.   codeCheck.exe --scan-tag basecode --source-location "d:\\workshop\\gelcorp"   SAS artifacts such as SAS Catalogs, Stored Processes, Enterprise Guide Projects and User-written code in Data Integration Studio jobs cannot be processed directly by Code Check. A companion tool, Gather SAS Code, can generate SAS code from these artifacts and write it to the file system, supporting code assessment with Code Check.   gatherSASCode.exe --all codeCheck.exe --scan-tag bidi --source-location "d:\\workshop\\SAS9ContentAssessment\\assessment\\gatheredSASCode"   Multiple Code Check reports focus on each type of artifact; the format of each report is the same. In this post, we will use the SAS 9 Code Check for the SAS Viya Report, which surfaces the results for all scanned items.   Select any image to see a larger version. Mobile users: To view the images, select the "Full" version at the bottom of the page.   What can we learn?   Let’s look at the SAS 9 Code check for SAS Viya Report to see what we can learn.   The overview page summarizes all the programs scanned and provides general statistics such as the % Compatible Programs, % Incompatible Programs, % Compatible Statements, % InCompatible Statements, etc. From this page, you can understand how easy or difficult it will be to run these SAS programs on SAS Viya. The tag filter allows the user to subset the report based on the scan tag. In our case we will select the “basecode” scan tag to focus on the results for SAS programs stored on the file system.     Let’s look at the incompatible programs to see what issues the reports surface.   One key thing we can discover in the report is which SAS programs have syntax elements that are not supported. This information is provided on the Incompatible Programs Tab. The report below shows three categories of incompatibility.   PROCEDURE: a SAS procedure that does not run on SAS Viya ASSIGNMENT: an assignment statement that uses a syntax element not available in SAS Viya LIBNAME: a libname statement that will not work on SAS Viya     You can click on a row in the table to see the line of code with the incompatible statement. Let us look at one from each category. The first row in the report shows an incompatibility related to the LIBNAME statement. The details show that the line uses an information map libname. Information maps are a 9.4 artifact that does not exist in SAS Viya.      The PROCEDURE category surfaces SAS procedures that will not run in Viya. If we use the filter on the left, we can see that our code contains 8 procedures that will not run on SAS Viya. The procedures operate on the Metadata Server or the LASR Analytic Server; neither server exists in SAS Viya.     The ASSIGNMENT category surfaces programming elements that are not available in SAS Viya. A review of these items shows they are all metadata data step functions. These functions cannot run in SAS Viya as SAS Viya has no metadata server.     In addition to incompatible code, the report also flags syntax elements that might have processing restrictions in Viya 4. On the SAS Viya platform, the SAS Compute Server and the SAS/CONNECT Server are LOCKDOWN enabled by default. This security measure in the SAS Viya Platform restricts access to specific system files and SAS language features. Here are some key reasons that LOCKDOWN disables features:   Access Methods: Methods like EMAIL, FTP, HTTP/URL, and SOCKET are disabled to prevent unauthorized data transfer and communication, which could expose the system to security vulnerabilities. SAS Language Features: Features such as PROC GROOVY, PROC JAVAINFO, and PROC PYTHON are disabled to limit the execution of external code that could potentially harm the system or access sensitive data. Functions and CALL Routines: Functions like ADDR and ADDRLONG are restricted to prevent direct memory access, which could be exploited to manipulate or extract data inappropriately.   These restrictions help maintain a secure and controlled environment, ensuring only authorized and safe operations are performed within the SAS Viya environment. SAS 9.4 was more permissive than SAS Viya so the Code Check report flags, functions, access methods, procedures, and features in the code that may not run by default in SAS Viya. If you attempt to use a resource that is locked down, SAS issues an error message to the SAS log.   The Code Check report surfaces this information in the Review:Warnings tab. The report shows that our code has some elements that may not run by default in SAS Viya.     The Review Hard-coded paths tab lists the locations in the SAS 9 code where file system paths are referenced. In SAS Viya running on Kubernetes, the paths to files on the file system, such as SAS programs, data files, etc., may differ from those in SAS 9.4. You can use the report to identify hard-coded paths in libname and filename statements, SAS procedures, %include statements etc.     The report has two tabs we have not covered: Review: Library Engines and Advanced: Explore Details. The Library Engines tab documents all the library engines used in the SAS programs, and Explore Details allows us to drill down on the CodeCheck results in several different ways.   What do we do with what we learned?   Now that we have reviewed the content of the Code Check report, what can we do with what we have learned?   The code flagged as incompatible must be rewritten for use in SAS Viya. Any code that accesses the SAS Metadata server will no longer work in SAS Viya. In the SAS Viya architecture, the information stored in the SAS 9..4 metadata server is stored in other places like the SAS Infrastructure Data Server and the SAS Configuration Server. In SAS Viya, similar functionality is available using the SAS Viya REST APIs. Another example of a change is PROC IMSTAT, which was used to process data in the SAS 9 LASR Analytic server and would likely be replaced by PROC CAS to process data in the CAS Server in SAS Viya. The table below presents some common incompatibilities (thanks to Joseph Kneen for creating this table).     Code with processing restrictions may be a little easier to deal with. Some elements can potentially be replaced with other, more secure techniques. An alternative to changing the code in SAS Viya is to modify the LOCKDOWN settings to allow the restricted elements to execute. Lockdown can be modified to allow specific features. Check out the SAS Viya documentation regarding using the LOCKDOWN System Option and the LOCKDOWN Statement. This approach has some risks, as the SAS Viya environment will not be fully secured. However, this could be done temporarily and/or in a separate SAS Viya compute context until a more secure technique is implemented.   The report also flagged hard-coded file system paths, which, in many cases, may need to change in SAS Viya. If the hard-coded paths need to be changed in SAS Viya, then help is available. Another SAS Content Assessment Application, modifySASCode, can update paths in SAS code in batch. Before running modifySAScode, you need to execute Code Check. The Code check results are copied to the ASSESSMENT_INFILES directory in the Content Assessment install directory. The modifySASCode application uses the results to generate a mapping CSV file. You edit the mapping CSV file to map the old paths (SAS 9) to the new paths(SAS Viya). ModifySASCode uses the mapping CSV file to apply the new, modified paths to the SAS program files. It updates new copies of the SAS program files in the specified output location. It does not update any original SAS program files. Comments for each update are written in the new SAS program files. Check out this video to see CodeCheck and the modifySASCode application in action.   Wrap up   SAS 9 Code Check examines SAS programs to determine their compatibility with SAS Viya by analyzing SAS 9 code stored in program files on the file system. A companion application, gatherSASCode, can generate SAS code from SAS 9 artifacts to be processed by code check. It checks for syntax elements that are not supported in SAS Viya 4, syntax elements that might have processing restrictions in SAS Viya 4, and hard-coded physical paths.   The code check results are presented in a series of reports. The reports can be used in the migration planning phase to identify the level of effort required to migrate SAS 9 Code to SAS Viya. The report's details can help plan and execute the migration of SAS code to SAS Viya.   Here are some related resources, including the first two posts in this series:   POST: SAS 9 Content Assessment: Application Usage  POST: SAS 9 Content Assessment: Inventory SAS Demo | Using the modifySASCode Content Assessment Application – YouTube POST: Content Assessment: SAS 9 Code Check for Internationalization CLASS: Migrating SAS 9.4 Content to the SAS Viya Platform on learn.sas.com Content Assessment Download SAS 9.4 to Viya Content Migration Documentation SAS DEMO  | SAS Content Assessment Overview POST: Migrating from SAS 9 to Viya: what's the first step POST: Migration of Stored Processes to Jobs (update) POST: Content Assessment delivers utility applications to support SAS Viya Content Migration POST: Go with the flow; migrating Enterprise Guide Projects to SAS Studio Flows POST: SAS Viya 2021.2 – Migrating SAS Data Integration (DI) Studio Jobs to SAS Studio Flows POST: A first look at Migration from SAS 9.4 to Viya 4 SAS Demo | SAS Viya Migration of Enterprise Guide Project to SAS Studio Flows – YouTube SAS DEMO | Migrating SAS Data Integration Studio Jobs to SAS Studio Flows     Find more articles from SAS Global Enablement and Learning here. ... View more

In this second in a series of posts on the SAS 9 Content Assessment reports, we look at the SAS 9 Application Usage report and review what information the report provides, what conclusions can be drawn from the information, and what likely actions you would take after reviewing the report.   As a reminder, this series of posts does not cover how to run SAS Content Assessment applications; instead, it focuses on using the results. For information about running SAS Content Assessment, check out this post and this demo. In the first post in the series, we looked at the SAS 9 Inventory report, a great place to start when planning a migration from SAS 9.4 to SAS Viya. Now let’s look at the SAS 9 Application Usage.     SAS Content Assessment Application Usage   SAS Stored Process and Workspace Servers interact with SAS by creating a server process for each client connection. The client user who makes the request owns the server process. Each server process enables client programs to perform SAS processing and retrieve the results. When a client requests a SAS Server, the SAS Object Spawner manages the request. In SAS 9.4, many client applications use the SAS Object Spawner. The Object spawner logs each request for a server. Here is an excerpt from the Object Spawner logs showing a connection by user barbara using the Stored Process Web Application.   2024-11-17T00:02:01,685 INFO [00170292] :sasinst - New out call client connection (19019) for user barbara@meta01. 2024-11-17T00:02:01,685 INFO [00170292] :barbara@meta01 - New client connection (19015) accepted from server port 8591 for SAS token user barbara@meta01. APPNAME=Stored Process Web App 9.4. 2024-11-17T00:02:01,691 INFO [00170292] :barbara@meta01 - Created process 7537 using credentials sassrv for user barbara@meta01 (child id 895). 2024-11-17T00:02:01,812 INFO [00170302] :sasinst - New out call client connection (19010) for launched server (child 895). Peer IP address and port are [::ffff:10.96.1.118]:35055. 2024-11-17T00:02:01,814 INFO [00170302] :sasinst - Client connection 19015 for user barbara@meta01 closed.   SAS Content Assessment uses the log records of the SAS Object Spawner to populate the data for the SAS 9 Application Usage report. That data includes information about:   Accessed applications Users invoking these applications     What can we learn?   The report contains historical trends and usage patterns by user and application.   The initial Overview page summarizes information on application usage. It identifies the number of SAS Object Spawners and the number of active users, applications, and total connections. This page gives you a general idea of the ongoing activity levels in your SAS 9.4 environment. You can subset the content by deployment or by SAS Object Spawner (in the case of an environment where multiple SAS Object Spawners are defined).   NOTE: be aware that results are derived from applications using the Object Spawner. Not all SAS 9 applications use the Object Spawner.     Select any image to see a larger version. Mobile users: To view the images, select the "Full" version at the bottom of the page.     The Timeline page graphs the volume of connections by user and application over time. On this page, you can identify the trends in the usage of your client applications. For example, our page shows a steady growth in the number of daily connections in November. The connection and user counts are grouped by application in the lower two graphs.       You can select a client application to see trends for that specific application. Below, we have selected the Stored Process Web Application.       The User Details page shows the usage history by user and application. For security reasons by default, user names are obfuscated and a mapping file is provided to match the real name to the obfuscated name (\SAS9ContentAssessment\assessment\results\user_map_final.csv).       Obfuscation has been turned off in the report below to better illustrate the content. The report lists the users by frequency of connection and can answer questions like:   Who is the most active user? Which users are inactive? Which SAS applications are being used the most? Which are being used the least? Is the usage of each type of application increasing or decreasing?   When interpreting the results be aware that there are some functional accounts in the report that are not tied to a real user, for example, sasev@saspw and sassrv.       What do we do with what we learned?   In the early stages of a migration engagement, the data in this report can help identify the mix of SAS Viya software needed to support the migration of the SAS 9.4 content. For example, if you see heavy usage of SAS Enterprise Miner, you know you will need SAS Visual Data Mining and Machine Learning on SAS Viya.   In addition, it can reveal usage patterns that might impact the effort and complexity of a migration. For example, the report above shows a high volume of SAS Stored Process Web Application usage. SAS stored processes migrate to SAS Viya jobs. This application's high usage suggests a next step: reviewing the SAS 9 Profile report for stored processes to gather more information about how they are used.   The report can identify the volume of usage in areas where automated migration is not fully supported, such as SAS Web Report Studio or SAS BI Dashboard. In planning a migration, alternate plans might be needed to support the content of these applications.   The Timeline page can help identify SAS 9 applications that are used and SAS 9 applications that are installed but not currently used.     Wrap Up   The SAS 9 Content Assessment Application usage report contains historical trends and usage patterns of SAS 9 Applications by user and time. Content Assessment retrieves the data for the report from the SAS 9 Object Spawner logs. The Application Usage report can help identify the usage patterns of SAS 9 software in preparation for migrating to SAS Viya. You can use the information on the report to plan for the software mix you may need in SAS Viya, to understand how the SAS 9 Software is used, and to determine how that usage can be maintained and enhanced in a Viya environment.   For further information on Migration from SAS 9.4 to Viya, check out these resources:   POST: SAS 9 Content Assessment: Inventory CLASS: Migrating SAS 9.4 Content to the SAS Viya Platform on learn.sas.com Content Assessment Download  SAS 9.4 to Viya Content Migration Documentation SAS Demo | SAS Content Assessment Overview - You Tube POST: Migrating from SAS 9 to Viya: What's the first step POST: Migration of Stored Processes to SAS Viya Jobs POST: Content Assessment delivers utility applications to support SAS Viya Content Migration POST: Content Assessment: SAS 9 Code Check for Internationalization POST: Go with the flow; migrating Enterprise Guide Projects to SAS Studio Flows POST: SAS Viya 2021.2 – Migrating SAS Data Integration (DI) Studio Jobs to SAS Studio Flows POST: A first look at Migration from SAS 9.4 to Viya 4 SAS Demo | SAS Viya Migration of Enterprise Guide Project to SAS Studio Flows – YouTube SAS Demo | Using the modifySASCode Content Assessment Application – YouTube SAS Demo | SAS Viya Migration of SAS Data Integration Studio Jobs to SAS Studio Flows - You Tube     ... View more

This is the first of an occasional series of posts where we will look at a Content Assessment report and take a deep dive to review what information the report provides, what conclusions can be drawn from the information, and what likely actions you would take after reviewing the report. This series of posts will not cover how to run Content Assessment applications; instead, it will focus on using the results. For details on running Content Assessment, check out this post and this demo. This post will look at the SAS 9 Content Assessment Inventory.   Content Assessment Inventory   Inventory is, in many ways, the simplest of the Content Assessment reports. However, that does not make it any less important; it is the place you will likely start when reviewing Content Assessment results. The SAS Viya Inventory application scans SAS 9 systems and documents the type and volume of content. The scan includes the Metadata Server, file system areas and deployment and license information. Let’s look at the report.   What can we learn?   The initial page, “What is Being Used,” provides an overview of the content in the scanned 9.4 environment. It includes a high-level summary of object counts broken down by the SAS Software offering used. In addition, it includes a ranked frequency table listing all types of SAS 9.4 items found.     Select any image to see a larger version. Mobile users: To view the images, select the "Full" version at the bottom of the page.   Drill to counts gives detailed counts by object type segmented by portfolio and offering. In this tab, we can see unique counts for all objects in the SAS 9 deployment. In conjunction with the Overview tab, this tab can be used to determine the type and volume of content.       A few key facts from the report. In terms of SAS 9 objects, the environment has:   SAS Enterprise Guide Project SAS OLAP Cubes SAS Information Maps SAS Data Integration Studio Jobs SAS Stored Processes SAS BI Reports SAS Visual Analytics Reports Access Control Templates (ACTs) In 2024.09, SAS 9.4 Users and Groups are included in the report. The User and Group names are obfuscated, and a mapping file is provided to match the real name to the obfuscated name (\SAS9ContentAssessment\assessment\results\user_map_final.csv).   Drill to items gives us access to the detailed location of individual objects in the metadata or on the file system. In the example below we can see the name and location of the SAS Data Integration Studio Jobs. Drill to items allows you to filter by Portfolio and Sellable offering. It also allows a filter by storage type where you can subset to objects stored on the OS filesystem or in SAS Metadata.       Filesystem Object Info provides an inventory of file-system content in the areas scanned by the inventory tool. In addition to the location and type, the last modified and last accessed dates are provided, allowing you to identify if objects are being used.       The final two tabs of the report, Software Version and Hotfix Info and Software License Info provide details on the software installed and licensed in the SAS 9 environment.   To summarize from the Inventory report, we can learn what:   types of content and configuration are in the SAS 9 environment is the volume of each type of content is the location of the content in metadata or the file system file system content has been recently updated or used   What do we do with what we learned?   The inventory results can provide input to a house-cleaning process on the SAS 9.4 environment. You may identify objects no longer used in the environment that you do not want to migrate to SAS Viya. Removing these objects at the source can make the migration more efficient. Make a plan to clean up any unused content from the source environment. Note that Inventory does not indicate whether a metadata object is being used. Information on some of the profile reports and the Content Assessment Application Usage report can used to determine usage levels of content. You can also have Enterprise Session Monitor running against the environment for a period of time and check those results.   The results of Inventory should provide a road map for which Profile reports you should focus on when planning the migration. SAS 9 Profile takes the analysis a step further and drills deeper into the specific characteristics of each type of object (report, job, cube, etc) found. SAS Content Assessment Profile contains a series of reports for each SAS 9.4 content type. The profile reports will give you additional information about the specifics of each content type. The specifics will influence the effort needed to migrate to SAS Viya.   Using inventory results, check for items that do not automatically migrate to SAS Viya. Our inventory has a few Web Report Studio Reports we know do not migrate to SAS Viya. In addition, we identified Access Control Template usage where we know there are limitations in the migration process. You can check the results against the “Resources that Migrate” section of the SAS Viya Administration guide. For SAS employees and Partners, the Migration Summary document can be used to get detailed information on what is and is not supported in relation to migration to SAS Viya.   To summarize, the results of inventory can be used to:   clean the SAS 9 environment before a migration direct the next steps in the assessment process plan for items that will not migrate automatically to SAS Viya   Wrap Up   Inventory is the simplest of the SAS Content Assessment reports. Creating an inventory is an important part of the migration assessment process and can help direct the next steps in planning a successful migration from SAS 9 to SAS Viya. We started with the easy one in this series, but stay tuned for a look at some of the other Content Assessment Reports. For further information on Migration from SAS 9.4 to Viya, check out these resources:   Course: Migrating SAS 9.4 Content to the SAS Viya Platform on learn.sas.com Content Assessment Download SAS 9.4 to Viya Content Migration Documentation  SAS Demo | SAS Content Assessment Overview Migrating from SAS 9 to Viya: What's the first step Migration of Stored Processes to Jobs (update) Content Assessment delivers utility applications to support SAS Viya Content Migration Content Assessment: SAS 9 Code Check for Internationalization Go with the flow; migrating Enterprise Guide Projects to SAS Studio Flows SAS Viya 2021.2 – Migrating SAS Data Integration (DI) Studio Jobs to SAS Studio Flows A first look at Migration from SAS 9.4 to Viya 4 SAS Demo | SAS Viya Migration of Enterprise Guide Project to SAS Studio Flows – YouTube SAS Demo | Using the modifySASCode Content Assessment Application – YouTube SAS Demo | Migrating SAS Data Integration Studio Jobs to SAS Studio Flows     Find more articles from SAS Global Enablement and Learning here. ... View more