Merlin AI

Beyond
Agentic AI

Domain-Focused Intelligence for SAS-to-Python Migration

Why deep migration intelligence beats generic code agents

sas.migryx.com

Migrate Smarter. Analyze Faster. Transform with MIGRYX.

M

The Challenge

Agentic AI Falls Short
in Enterprise Migration

Why Agentic AI Fails

⚡

Code-Only Focus

Generic agents treat migration as a simple translation task — ignoring data lineage, business logic, and risk.

🔍

No Domain Context

They don't understand SAS macros, PROCs, library references, or how files relate to each other.

⚠️

No Risk Intelligence

Zero visibility into migration complexity, missing dependencies, or which files need the most attention.

📊

No Project-Level Insight

Each file is processed in isolation — no understanding of dataset flows, execution patterns, or similarity.

What Enterprise Migration Actually Needs

Deep understanding of SAS constructs and their Python equivalents

Project-wide dependency analysis and lineage tracking

ML-driven risk scoring and migration difficulty assessment

Interactive UI for visual exploration, not just CLI output

Governance: checklists, reports, and actionable recommendations

Our Approach

Domain-Focused AI,
Not Generic Agents

Merlin AI is purpose-built for SAS-to-Python migration. Every feature — from context-aware chat to ML-driven risk analysis — is designed around the unique challenges of enterprise code modernization.

01

Context Intelligence

File, block, and project context flows into every AI interaction. Merlin understands your code structure, not just syntax.

02

Migration Analytics

ML clustering, risk scoring, similarity analysis, and dependency graphs provide actionable project intelligence.

03

Interactive Workflow

Overview → Convert → Validate → Optimize in a visual workbench with real-time AI assistance at every step.

Integrated Experience

Merlin AI Everywhere You Work

Not a separate tool — Merlin AI is embedded in every stage of the migration workflow.

⌨️

Workbench

File & block-level AI in your code editor

🔎

LogSense

Intelligent log analysis & conversion debugging

🔗

Data Match

Project-level chat & data match insights

📄

Reports

Project & file reports with deep insights

📝

DocStrings

AI-generated Python documentation

📈

Merlin Insights

Global analytics dashboard with ML intelligence

Core Capabilities

AI-Powered Migration Workflow

💬

Context-Aware Chat

File, block, or project context for relevant answers

🔄

Code Conversion

SAS → Python/PySpark with SAS-specific mapping

✅

Block Validation

Logic match, edge cases, engine compatibility

⚡

Code Optimization

Performance improvements and best practices

📋

DocString Generation

Auto-generated Python documentation per block

🧪

Synthetic Data

Generate test DataFrames for execution testing

MerlinAI Assistant

Overview

Convert

Validate

Optimize

/* SAS Source */

PROC SQL;

SELECT * FROM work.dataset

WHERE flag = 1;

QUIT;

# Python Output

df = spark.sql("SELECT * FROM dataset WHERE flag=1")

✓ Logic Match

✓ Compatible

Conversion Workflow

Convert, Validate, and Optimize — All In-Context

Code Validation

Logic Match94%

Edge Cases Covered88%

Engine Compatibility100%

✓ Accept

✗ Reject

Workbench — 4-Step Workflow

Overview

Convert

Validate

Optimize

Synthetic Data Panel

Agentic AI gives you code. Merlin AI gives you a validated, optimized, tested migration with full traceability.

Conversion Workflow

Execution Streams & Dataset Hotspots

Execution Streams — 15 Independent Streams

Parallelization analysis across all execution streams

Structural Complexity Hotspots

12

Fan-in nodes

8

Fan-out nodes

3

Circular deps

Agentic AI gives you code. Merlin AI gives you a validated, optimized, tested migration with full traceability.

Merlin Insights

Project Intelligence
No Agent Can Match

🔵 ML Clustering & Scoring

K-Means, DBSCAN, hierarchical clustering for file similarity and migration scoring

🔴 Risk Intelligence

Per-file risk scores from complexity, missing deps, and migration difficulty

🟣 Dependency Analysis

Macro, dataset, and include dependency graphs with entry/terminal point detection

🟢 Actionable Recommendations

Auto-convert, template-based, manual rewrite, or full redesign per file

ML Insights — Complexity vs Business Criticality

Complexity →

Criticality ↑

Critical

High

Low

Risk & Dependencies

Know Your Risk Before You Migrate

Risk Intelligence — Score & Distribution

Critical

15%

High

28%

Medium

42%

Low

15%

4

Risk Levels

Critical · High · Medium · Low

6+

Factors Analyzed

Complexity · I/O · Deps · LOC

182

Graph Coverage

Nodes across jobs & datasets

Dependencies Graph — 182 nodes, 187 links

MAIN
JOB

DS_01

DS_02

MACRO
LIB

PROC
SQL

OUT_A

OUT_B

OUT_C

DeepSights

Similarity Intelligence & Pattern Analysis

Identify similar files, shared patterns, and reusable templates to accelerate migration across your entire codebase.

DeepSights Overview — 43 files, 8 similar pairs, 6 groups

43

Files

8

Similar pairs

6

Groups

95%

Avg similarity

A01

A02

B01

C01

C02

D01

E01

F01

F02

G01

H01

H02

Convert one file in a similarity group → apply the same template to all. Agentic AI processes each file blind.

Similarity Network — Visual graph of file groups

Dataset Intelligence

Understand Data Flow Across Your Entire Project

Execution Streams — 15 independent streams

15 independent parallelizable execution streams identified

Structural Complexity Hotspots — Fan-in, fan-out, circular

🔗

Lineage Tracking

Upstream/downstream dataset relationships

⚡

Execution Pods

Independent stream identification

📊

Concentration Analysis

Pareto distribution & hotspot detection

🏷️

Data Domains

Automatic domain classification

Head to Head

Merlin AI vs Agentic AI Approach

Capability	✦ Merlin AI	Agentic AI
Code Conversion	SAS-specific mapping with macro/PROC handling	Generic LLM translation
Validation	Logic match + edge cases + engine compatibility	Basic syntax check
Risk Assessment	ML-driven per-file scoring with 6+ risk factors	Not available
Dependency Analysis	Full graph: macros, datasets, includes, entry points	Not available
Similarity Intelligence	DeepSights clustering, pattern reuse	Not available
Dataset Intelligence	Lineage, hotspots, execution streams, concentration	Not available
Interactive UI	Visual workbench, canvas, real-time panels	CLI / notebook output
Project Reports	HTML/PDF with insights, risk, recommendations	Not available

Architecture

Secure, Flexible, Enterprise-Grade

Frontend / UI Layer

Workbench Canvas

LogSense Panel

File/Block Overview & Convert

Data Match Tab

Validate / Optimize / Ask AI

Merlin Insights Dashboard

Deep Sights & Similarity

DocString Editor

Merlin Server (FastAPI)

File/Block Overview & Convert

Validate / Optimize / Ask AI

Session-based Chat History

Reports & Lineage Engine

HTML/JSON Report Generation

Merlin Insights Engine

GenAI Client Abstraction

ML Analyzer (K-Means, DBSCAN)

Dataset Intelligence Analyzer

Risk Intelligence Analyzer

Deep Sights & Similarity

AI Backend Flexibility

OpenAI

Google Gemini

AWS Bedrock

Cortex

Custom GenAI

Business Value

Why Merlin AI Delivers
Superior Outcomes

60%+

Faster Migration

Automated conversion, validation, and optimization — not just code generation

100%

On-Premise Security

Full deployment behind your firewall with zero data leakage

4-Step

Validated Quality

Overview → Convert → Validate → Optimize with accept/reject at every step

ML

Intelligent Prioritization

Risk scoring tells you exactly where to focus manual effort

Full

Project Visibility

Dependency graphs, lineage, execution streams — not just file-level output

Deep

Reuse & Templates

Similarity groups let you convert once and apply across related files

Merlin AI

Migrate Smarter.
Analyze Faster.
Transform with MIGRYX.

Domain-focused AI that understands your SAS codebase, not just your code.

sas.migryx.com hello@migryx.com

M

Agentic AI Falls Shortin Enterprise Migration