Skip to the content
LeaplogicLeaplogic
  • Home
  • About Us
  • Contact
SIGN IN
  • Home
  • About Us
  • Contact

  • Getting Started
    • Before You Begin
    • Creating an Account
    • Logging into LeapLogic
    • Reset Password
    • Quick Tour of the Web Interface
    • LeapLogic in 15 minutes
      • Prerequisites
      • Step 1. Log into LeapLogic
      • Step 2. Create Assessment and Get Insights
      • Step 3. Create Transformation Pipeline and See Results
      • Step 4. Edit or Optimize the Transformed Code
      • Step 5: Complete the Transformation Lifecycle
  • Introduction to LeapLogic
    • Overview
    • High Level Architecture
    • Supported Legacy and Cloud Platforms
    • Key Features
  • Workload Assessment
    • Overview
    • Value Proposition
    • Creating Assessment
      • Prerequisites
      • Step 1. Provide Primary Inputs
        • Automation Coverage
      • Step 2. Add the Additional Inputs
        • Table Stat Extraction Steps
          • Teradata
          • Oracle
          • Netezza
      • Step 3. Update the Source Configuration
      • Step 4. Configure the Recommendation Settings
    • Assessment Listing
    • Understanding Insights and Recommendations
      • Volumetric Info
      • EDW
        • Oracle
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • Vertica
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • Snowflake
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • Azure Synapse
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • SQL Server
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • Teradata
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • Netezza
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • Google Big Query
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • Redshift
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • PostgreSQL
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • Duck DB
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • ClickHouse
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • Exasol
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • DB2
          • Highlights
          • Analysis
          • Optimization
          • Recommendations
          • Lineage
          • Downloadable Reports
      • ETL
        • Informatica
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
        • Ab Initio
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
        • DataStage
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
        • Talend
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
        • SSIS
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
        • Informatica BDM
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
        • Oracle Data Integrator
          • Highlights
          • Analysis
          • Downloadable Reports
        • Pentaho
          • Highlights
          • Analysis
          • Downloadable Reports
        • Azure Data Factory
          • ARM Template
          • Highlights
          • Analysis
          • Downloadable Reports
        • Matillion
          • Highlights
          • Analysis
          • Downloadable Reports
        • SnapLogic
          • Highlights
          • Analysis
          • Downloadable Reports
      • Orchestration
        • AutoSys
          • Highlights
          • Analysis
          • Downloadable Reports
        • Control-M
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
        • SQL Server
          • Highlights
          • Analysis
      • BI
        • OBIEE
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
        • Tableau
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
        • IBM Cognos
          • Highlights
          • Analysis
          • Downloadable Reports
        • MicroStrategy
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
        • Power BI
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
        • SSRS
          • Highlights
          • Analysis
          • Downloadable Reports
        • SAP BO
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
        • WebFOCUS
          • Highlights
          • Analysis
          • Downloadable Reports
      • Analytics
        • SAS
          • Highlight
          • Analysis
          • Lineage
          • Downloadable Reports
        • Alteryx
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
      • Integrated Assessment (EDW, ETL, Orchestration, BI)
        • Highlights
        • Analysis
        • Optimization
        • Lineage
        • Recommendations
    • Managing Assessment Reports
      • Downloading Report
      • Input Report Utility
      • View Configuration
    • Complexity Calculation Logic
    • Key Benefits
    • Ad hoc Query
  • Metadata Management
    • Overview
    • Introduction to Data Catalog
      • Managing Data Catalog
        • Building Data Catalog
        • Insights to Data Catalog
        • Managing the Repository and Data Source
      • Creating Repository (Repo)
      • Creating Data Source
    • Tag Management
    • Key benefits
  • Batch Processing using Pipeline
    • Introduction
    • Designing Pipeline
      • How to create a pipeline
        • Configuring Migration Stage
          • Schema Optimization
        • Configuring Transformation Stage
          • On-premises to Cloud
          • Cloud-to-Cloud
          • LeapLogic Express
        • Configuring Validation Stage
          • Data Validation
            • Table
            • File
            • File and Table
            • Cell-by-cell validation
          • Query Validation
            • Query Validation (When Data is Available)
            • Query Validation (When Data is Not Available)
          • Schema Validation
        • Configuring Execution Stage
        • Configuring ETL Conversion Stage
          • Ab Initio
          • Informatica
          • Informatica BDM
          • Matillion
          • DataStage
          • SSIS
          • IICS
          • Talend
          • Oracle Data Integrator
          • Pentaho
          • SnapLogic
        • Configuring Mainframe Conversion Stage
          • Cobol
          • JCL
        • Configuring Orchestration Stage
          • AutoSys
          • Control-M
        • Configuring BI Conversion Stage
          • OBIEE to Power BI
          • OBIEE to AWS QuickSight
          • Tableau to Amazon QuickSight
          • Tableau to Power BI
          • Tableau to Superset
          • Tableau to Looker
          • IBM Cognos to Power BI
        • Configuring Analytics Conversion Stage
          • SAS
          • Alteryx
        • Configuring Script Conversion Stage
    • Key Features
      • How to schedule a pipeline
      • Configuring Parameters
  • Pipeline Reports
    • Overview of Pipeline Report
    • Pipeline Listing
    • Reports and Insights
      • Migration
      • Transformation
        • On-premises to Cloud
        • Cloud-to-Cloud
        • LeapLogic Express
      • Validation
        • Data
          • File
          • Table
          • File and Table
        • Query
          • Query Validation Report (When Data is Available)
          • Query Validation Report (When Data is not Available)
        • Schema
      • Execution
      • ETL
        • Ab Initio
        • Informatica
        • Informatica BDM
        • Matillion
        • DataStage
        • SSIS
        • IICS
        • Talend
        • Oracle Data Integrator
        • Pentaho
        • SnapLogic
      • Mainframe
        • Cobol
        • JCL
      • Orchestration
        • AutoSys
        • Control-M
      • BI
        • OBIEE to Power BI
        • OBIEE to Amazon QuickSight
        • Tableau to Amazon QuickSight
        • Tableau to Power BI
        • Tableau to Superset
        • Tableau to Looker
        • IBM Cognos to Power BI
      • Analytics
        • SAS
        • Alteryx
      • Shell Script
      • Common Model
    • Automation Level Indicator
      • ETL
        • Informatica
        • Matillion
        • DataStage
        • Informatica BDM
        • SnapLogic
        • IICS
        • Ab Initio
        • SSIS
        • Talend
        • Pentaho
      • Orchestration
        • AutoSys
        • Control-M
      • EDW
      • Analytics
        • SAS
        • Alteryx
      • BI
      • Shell Script
    • Error Specifications & Troubleshooting
  • SQL Transformation
    • Overview
    • Creating and Executing the Online Notebook
      • How to Create and Execute the Notebook
      • Supported Features
    • Configuring the Notebook
      • Transformation
      • Unit Level Validation
      • Script Level Validation
    • Notebook Listing
  • Operationalization
    • Overview
      • Basic
      • Advanced
      • Cron Expression
    • Parallel Run Pipeline Listing
  • Transformation Source
    • Introduction
    • Creating Transformation Source Type
  • Governance
    • Summary of Governance - Roles and Permissions
    • User Creation
      • Creating a new User Account
    • Adding Roles and permissions
      • How to add Roles and Permissions to a new user?
    • Adding Group Accounts
    • Default Quota Limits
    • Product Usage Metrics
  • License
    • EDW
    • ETL
  • LeapLogic Desktop Version
    • Overview
    • Registration and Installation
    • Getting Started
    • Creating Assessment
      • ETL
      • DML
      • Procedure
      • Analytics
      • Hadoop
    • Reports and Insights
      • Downloadable Reports
      • Reports for Estimation
    • Logging and Troubleshooting
    • Sample Scripts
    • Desktop vs. Web Version
    • Getting Help
  • LeapLogic (Version 4.8) Deployment
    • System Requirements
    • Prerequisites
    • Deployment
      • Extracting Package
      • Placing License Key
      • Executing Deployment Script
      • Accessing LeapLogic
    • Uploading License
    • Appendix
    • Getting Help
  • Removed Features
    • Configuring File Validation Stage
    • Variable Extractor Stage
      • Variable Extractor Report
    • Configuring Meta Diff Stage
      • Meta Diff
    • Configuring Data Load Stage
      • Data Load
    • Configuring Multi Algo Stage
  • FAQs
  • Tutorial Videos
  • Notice
Home   »  Workload Assessment   »  Understanding Insights and Recommendations   »  Analytics  »  SAS Assessment Report

SAS Assessment Report

This topic contains information about the SAS assessment report. SAS is one of the most popular analytics systems used in the industry. The assessment assesses workloads and produces in-depth insights that help to plan the migration. The input formats for the SAS assessment are SAS or EGP files.

In This Topic:

  • Highlights
    • Summary
    • Complexity
  • Analysis
    • Source Analysis
    • Artifacts
  • Lineage
  • Downloadable Reports
    • Insights and Recommendations
    • Source Inventory Analysis
    • Lineage Report


Highlights

The highlights section gives you a high-level overview of your assessment summary of the analytics performed on the selected workloads. It includes a graphical depiction of the complexity of files as well as the summary of the files used.

Summary

This section illustrates the SAS based analytical scripts that were analyzed across the various elements. Here you can see the number of files, the percentage of available procedural and statistical scripts, the percentage of code analyzed and more.

  • Files: Displays the total number of input files.
  • SQL + SAS Procedural: Displays the percentage of workloads that consist of SQL and SAS Procedural code.
  • SAS Statistical (Base Proc): Displays the percentage of workloads that consist of SAS Statistical (Base Proc) code.
  • Automation: Displays the anticipated automation conversion percentage.
  • Duplicate Files: Displays the number of duplicate files present in the input files.
  • Partly Duplicate Files: Displays the number of partially duplicate files present in the input files.

Complexity

This section provides a summarized graphical representation of the complexity of SAS scripts that helps in making different decisions, including budget estimation. The complexity of the SAS script is calculated based on various parameters like external access, conditional procedural statement, external resources, total SQL statement, and procedures.


Analysis

This topic provides a detailed examination of source files and artifacts.

Source Analysis

This section provides a comprehensive report of the SAS script including file complexity, queries executed, and so on. It also shows the number of macros, proc SQL, data steps, etc. for every SAS script.

  • File Name: Name of the file.
  • Macros: Displays the number of macros in the file.
  • Proc SQL: Displays the number of Proc SQL in the file.
  • Data Steps: Set of instructions to manage (create or modify) data sets.
  • Complexity: Displays the complexity of SAS script.
  • Conditional Procedural Constructs: Group of conditional statements including do loop statement count, if statement count, where statement count, do over statements count, array statement count, let statement count, put statement count, symdel statement count, and else_cond count.
  • External Data Access: Group of statements including lib name statement count, and ods count.
  • Base SAS Procs: Procedural statements in SAS including proc append count, proc calendar count, proc catalog count, proc chart count, etc.
  • Advanced SAS Procs: Procedural statements in SAS including proc access count, proc aggregation count, proc allele count, proc anom count, proc appsrv count and more.
  • Analyzed Percentage: Percentage of analyzed files.

Artifacts

This page gives details about artifacts-collections of related server data. It provides a list of files that could not be parsed completely due to some error.

  • File Name: Displays the name of the unparsed file.
  • Type: Displays the type of each file.
  • Error on Line Number: Displays the line number where the error occured.

Lineage

End-to-end process lineage identify the complete dependency structure through interactive and drill-down options to the last level.

Typically, even within one line of business, multiple data sources, entry points, ETL tools, and orchestration mechanisms exist. Decoding this complex data web and translating it into a simple visual flow can be extremely challenging during large-scale modernization programs. The visual lineage graph adds tremendous value and helps define the roadmap to the modern data architecture. It deep dives into all the existing flows and provides integrated insights. These insights help data teams make strategic decisions with greater accuracy and completeness. Enterprises can proactively leverage integrated analysis to mitigate the risks associated with migration and avoid business disruption.

LeapLogic’s lineage helps to trace the complete data flow in steps. The visual representation helps to track how the data hopped and transformed along the way, with details of parameter changes, etc. It provides backward and forward lineage showing the hops and reference points of data lineage with a complete audit trail of the data points of interest. They also help temporarily ignore peripheral, unwanted data points and establish useful correlations between data points to uncover hidden patterns and results. Users can deep dive into certain flows leveraging next-gen features like contextual search, advanced filters according to workload type, an interactive visual interface, graph depth, and more.

Now, let’s see how you can efficiently manage lineage.

To view the required lineage:

  1. Select either the Process or Data tab.
  2. Enter the keywords in the Search Keywords field.
  3. Click the Search icon to generate the lineage.

Process lineage illustrates the dependencies between two or more processes such as EGP files, SAS files, etc., whereas data lineage depicts data flow between two or more data-holding components such as entities, flat files, etc. In addition, the filter search icon allows you to include or exclude particular nodes to obtain the required dependency structure. You can also choose the direction of the lineage. By default, the Dependency Direction is Left to Right Hierarchy. You can also choose Right to Left Hierarchy or Bidirectional dependency directions as required. Moreover, you can also increase the Hierarchy Levels to nth level.

Lineage facilitates you visualize how your selected nodes are connected and depend on each other. The nodes and their connecting edges (relationships) help you to understand the overall structure and dependencies.

Nodes Edges
Tables Call
File Read
Stage Execute
Bridge Table Write
OTHERS

Manage Lineage

This feature enables you to view and manage your lineage. You can add, modify, or delete nodes and their relationships to generate an accurate representation of the required dependency structure. There are two ways to update the lineage: either using Complete Lineage report or Lineage Template.

Using Complete Lineage report

Follow the below steps to modify the lineage:

  1. Click the Manage Graph icon.
  1. Click Download Complete Lineage to update, add, or delete the nodes and their relationships in the current lineage.
    1. Once the complete lineage report is downloaded, you can make necessary updates such as updating, deleting or adding the nodes and its relationships.
    2. After making the required changes, upload the updated lineage report in Upload to Modify Lineage.
    3. Click Apply to incorporate the updates into the dependency structure.
    4. Generate the required process or data lineage.

    Using Lineage Template

    Follow the below steps to add new nodes and their relationships to the current lineage report:

    1. Click the Manage Graph icon.
    1. Click Download Lineage Template.
    1. Once the lineage template is downloaded, you can add new nodes and relationships in the template.
    2. After making the required changes, upload the template in Upload to Modify Lineage.
    3. Click Apply to incorporate the updates into the complete dependency structure.
    4. Generate the required process or data lineage.

    Important:

    To effectively manage lineage, you must adhere to the following rules:

    • Do not modify the column headers or their order in the Complete Lineage report or the Lineage template. The following are the column headers: source_name, source_type, target_name, target_type, relation_type, and database_id.
    • When deleting a row, retain the value in the database_id column and clear all the other column values.
    • When inserting a row, add all the column values except in the database_id column.
    • When updating a row, ensure that all the columns have relevant data.

    You can also apply:

    FeatureIconUse
    FilterUsed to filter the lineage.
    ReloadAssists in reloading graphs.
    SaveUsed to save the lineage.
    DownloadUsed to download the file.
    ExpandUsed to enlarge the screen.

    Downloadable Reports

    Downloadable reports allow you to export detailed SAS assessment reports of your source data which enables you to gain in-depth insights with ease. To access these assessment reports, click Reports.

    Types of Reports

    In the Reports section, you can see various types of reports such as Insights and Recommendations, Source Inventory Analysis, and Lineage Report. Each report type offers detailed information allowing you to explore your assessment results.

    Insights and Recommendations

    This report provides an in-depth insight into the source input files. It contains the final output including information about analyzed SAS scripts, complexity measures, functions, variable references, file duplicacy, and more.

    Here, you can see the sas folder and the SAS_Code_Assessment.xlsx report.

    SAS_Code_Assessment.xlsx: This report provides insights about the source inventory. It helps you plan the next frontier of a modern data platform methodically. It includes information about complexity measures, functions, variable references, overall duplicacy, EGP duplicacy, and more.

    This report contains the following information:

    This report contains the following information:

    • Report Summary: Provides information about all the generated artifacts.
    • Summary: Lists detailed inventory for SAS and EGP files. For instance, it provides information about number of files with compilation errors, parsing errors, missing files, extent of auto-conversion, complexity analysis, and so on.
    • Complexity Measures: Provides high-level complexity details of each SAS file. It includes information about formula used to derive the complexity, total lines of code, percentage of auto-conversion, number of lines of code which have valid code for conversion, number of macros defined, and a lot more.
    • Overall Duplicacy: Provides the overall resemblance index by comparing tasks and steps. It marks all those tasks duplicate which either meet or exceed the predefined similarity threshold. The tasks which are successfully compare are marked as Success in Status else an error message is displayed.
    • EGP Duplicacy: Provides the EGP file resemblance index by comparing each EGP file with all the other input EGP files. It marks all those EGP files duplicate which either meet or exceed the predefined similarity threshold. The EGP files which are successfully compare are marked as Success in Status else an error message is displayed.
    • EGP Complexity Measures: Provides details about complexity measures for the EGP files. It includes percentage of auto conversion, number of lines of code, number of non-converted code lines, count of proc SQL and so on.
    • Discovery: Lists key metrics related to auto-converted code. It includes code parsing status, the number of non-converted code lines, compilation status, percentage of auto-conversion, and likewise.
    • Manual Conversion: Provides more granular auto-conversion metrics such as statements like format, date, length, increment, etc., that need manual intervention. It also provides the count of statements, procs, etc. that need manual intervention in the format “ToDo Automatic Comment “.
      • Step 1: In the Discovery sheet, if Compile and Parsing status are failed consider it for manual conversion.
      • Step 2: In the Missing Source Code sheet, if you find an entry there, do not proceed with the manual conversion. We need to first get the missing files from the customer and then do the end-to-end conversion.
      • Step 3: In the Manual conversion sheet, if % auto-conversion is more than 20% then ask for code re-conversion and statement-wise count for manual conversion.
      • Step 4: In the Manual Patterns sheet, refer to the details of code blocks that need manual conversion.
    • Manual Patterns: Provides details of code blocks that need manual conversion. It includes information about the statement types which are not auto-converted, code for manual conversion, partially auto-converted code but requires minor changes, and describes actions required for manual conversion.
    • Inputs and Outputs: Lists all the inputs existing in the SAS file along with its type such as READ, Lookup, New Dataset, etc. It also lists the outputs and its type such as a file, etc.
    • Functions: Lists all the functions occurring in a SAS file along with their usage status.
    • Variable Reference: Lists all the variables existing in a source SAS file along with its values appearing in the code. It also lists the types of entities such as macro calls, LET, etc.
    • Common Functions: Lists all the common functions in the source code file along with their availability and known issues.
    • Compilation Errors: Provides information about the compilation error in each source file.
    • Parsing Errors: Provides information about unparsable code.
    • Dependent Source Code: Lists dependent files for different source files.
    • Complexity Calculation Logic: Provides complete high-level details required for complexity calculations. It includes information about the Group Statements – collection of statements and lists all the SAS base functions. It also provides the complexity range based on an established complexity calculation logic, the assessment engine calculates the complexity of SAS scripts and its components and shows it in a range format for each SAS statement type and function.

    Browse through sas folder to access SAS Analysis DB.xlsx report.

    SAS Analysis DB.xlsx: This report provides information about the analyzed SAS scripts.

    This report contains the following information:

    • Report Summary: Provides information about all the generated artifacts.
    • SAS Analysis DB: Provides information about the analyzed SAS scripts. It includes information about the complexity, the number of macros, proc SQL, data steps, etc., for every SAS script.

    Source Inventory Analysis

    It is an intermediate report which helps to debug failures or calculate the final report. It includes all the generated CSV reports such as entities_used.csv and querywise_entity_details.csv.

    entities_used.csv: This report provides information about the tables associated with the analyzed or supported queries.

    querywise_entity_details.csv: This report provides information about entities or tables associated with each query. It also includes information about database types, schemas, number of columns, and more.

    Lineage Report

    This report provides complete dependency details for all nodes. It provides an end-to-end data and process lineage that helps to identify the complete dependency structure and the data flow.

    This report contains the following information:

    • Dependency (Process): Provides information about the process lineage.
    • Dependency (Data): Provides information about the data lineage.
    • Dependency (Data Model): Provides dependency details about the data models.
    • Nodes: Lists all the source and target nodes along with their type.
    • Volumetric Info (Summary): Provides volumetric information about the artifact types such as input tables, output tables, and more.


    To learn more, contact our support team or write to: info@leaplogic.io

    Copyright © 2025 Impetus Technologies Inc. All Rights Reserved

    • Terms of Use
    • Privacy Policy
    • License Agreement
    To the top ↑ Up ↑