01
Read the estate
Analyse SAS programs together with execution logs, including code produced through macro execution.
SAS estate intelligence
ELSii is your SAS column-level lineage database.
Built from your SAS programs and execution evidence, ELSii reconstructs how data moves and transforms across your estate — from tables and columns through calculations and dependencies, with traceability back to the supporting SAS code.
CUSTOMERDOB
TRANSACTIONTXN_DATE
CALCULATIONINTCK('year', DOB, TXN_DATE)
REPORT.OUTPUTCUSTOMER_TENURE
The migration question
How well do you really understand the SAS estate you are about to migrate?
Long-lived SAS estates hide years of business logic. ELSii helps surface it before migration starts.
Trace tables and columns through the estate
Expose calculations, transformations and dependencies
Recover macro-generated SAS from execution evidence
Keep supporting code and unresolved areas visible
Use the lineage for migration, impact analysis and decommissioning
What ELSii does
From SAS source and logs to evidence-backed lineage.
The analysis is layered. ELSii first understands the source, then brings in runtime evidence where additional execution context is needed, resolves semantic and physical identities, reconstructs individual instances, and builds the lineage database.
02
Resolve relationships
Identify libraries, tables, columns, transformations and calculations across programs and processes.
03
Reconstruct instances
Distinguish each table input, output and successive overwrite so repeated uses of the same SAS table name are not flattened into one object.
04
Build the lineage database
Create structured lineage and supporting evidence that can be queried, exported, integrated and explored through downstream tools.
Where could ELSii help you?
One lineage database. Many practical uses.
Once the SAS estate has been reconstructed at table, column and calculation level, the same evidence base can support work across migration, change and ongoing estate understanding.
Migration & modernisation
Understand what must be carried forward before SAS logic is rebuilt in another technology.
Impact analysis
Trace upstream sources and downstream dependencies before changing a table, variable or calculation.
Decommissioning & rationalisation
See what depends on a process or dataset before deciding whether it can safely be retired.
Investigation & troubleshooting
Follow an output back through intermediate variables, calculations and supporting SAS code.
Documentation & provenance
Create a structured evidence base for inherited or poorly documented SAS estates.
Migration acceleration
Use structured lineage and transformation evidence as an input to downstream migration, documentation or code-generation tooling.
What is the ELSii product?
The lineage database sits at the centre.
ELSii analyses SAS programs and execution evidence, reconstructs the estate into a structured and enriched lineage database, then makes that intelligence available to the tools and people that need it.
SAS programs + execution evidenceELSii EngineInterpret · resolve · reconstruct
→
THE PRODUCTELSii Lineage DatabaseTables · columns · calculations · dependencies · evidence
→
Enterprise lineage graphics
ELSii HTML visualiser
Impact analysis
Migration tooling
Documentation
AI / downstream analysis
Built for difficult SAS
Not just program-to-program arrows.
ELSii is designed around the realities of SAS estates: generated code, layered transformations, reused variables, multiple intermediate datasets and logic that is difficult to reconstruct manually.
Column lineageTrace variables through tables and transformations.
Calculation lineageSee how derived columns are created and propagated.
Macro executionUse execution evidence to see code actually generated at run time.
Coverage evidenceSeparate what is resolved from what still needs investigation.
What you receive
Lineage you can inspect, query and use.
Structured lineage data
Tables, columns, calculations and dependencies captured as structured, integration-ready lineage records.
Visual lineage
Clear views for tracing a variable, table or process through the estate.
Supporting evidence
Trace lineage relationships back to the relevant SAS program, step, statement, source position and calculation context.
Direct + ultimate sourcesFollow immediate dependencies or trace through intermediate tables to origin.
Table + variable instancesDistinguish individual inputs, outputs and successive overwrites rather than relying on names alone.
Code evidenceKeep lineage tied to program, step, statement and source position.
Resolution statusSeparate supported conclusions from fallback, unresolved or review items.
About ELSii
Built from decades of working inside SAS estates.
ELSii is developed by Real Fruit Pty Ltd, incorporated in 1999. Founder Allison Low has been programming in SAS since 1992, with experience spanning government, pharmaceuticals and clinical research, insurance, banking, credit bureaux, and university and research environments.
Approaching MVP
Want to see ELSii on a real SAS process?
ELSii is currently being demonstrated to organisations working with complex SAS estates and migration programmes.