Results

What ELSii actually gives you.

The visual lineage is one way to explore ELSii. The structured lineage database is the product: it holds the relationships, transformations and supporting evidence behind the lineage.

See what ELSii knows

Explore your SAS estate in 90 seconds.

See ELSii trace rich lineage through jobs, tables, columns, calculations and supporting SAS code.

From SAS code to rich column-level lineage

Three real ELSii examples.

These examples show the same progression used in the ELSii demo: SAS code or logs → the ELSii parsing engine room → column-level lineage graphics. Each example exposes different SAS behaviour and the evidence ELSii reconstructs behind it.

Example 01

Lineage of final_average

A calculation-focused example showing SAS source, the structured engine-room evidence and the resulting column lineage.

01SAS code or logs
SAS code or log evidence for Lineage of <code>final_average</code>
02ELSii Parsing Engine Room
ELSii parsing engine room evidence for Lineage of <code>final_average</code>
03Lineage Graphics
LEVEL0_SOURCE
LEVEL1_CALCULATED
LEVEL2_FINAL
Detailed ELSii lineage evidence for final_average
Example 02

Ambiguous SAS code

Shows how ELSii carries the supporting context needed to resolve lineage where a variable name alone is not sufficient.

01SAS code or logs
SAS code or log evidence for Ambiguous SAS code
02ELSii Parsing Engine Room
ELSii parsing engine room evidence for Ambiguous SAS code
03Lineage Graphics
LENGTH
SUM
X
Detailed ELSii lineage evidence for ambiguous code output X
Example 03

Lineage of widget_a_qty

A multi-input example showing how ELSii traces a target column through calculations and source variables.

01SAS code or logs
SAS code or log evidence for Lineage of <code>widget_a_qty</code>
02ELSii Parsing Engine Room
ELSii parsing engine room evidence for Lineage of <code>widget_a_qty</code>
03Lineage Graphics
STG.ORDERS.ITEM
STG.ORDERS.QTY
WIDGET_A_QTY
Detailed ELSii lineage evidence for widget_a_qty
Connect the lineage

A flexible lineage database — use your graphics tool or ours.

The ELSii lineage database can connect to your organisation’s enterprise lineage or visualisation tools. This example uses ELSii JSON with our HTML visualiser, providing searchable, interactive and drillable lineage with detailed column evidence and SAS source. The HTML visualiser can also be tailored to your needs.

Example ELSii lineage interfaceInteractive full graph with detailed column evidence
REAL OUTPUT
Example ELSii lineage interface showing job navigation, full lineage graph and column details
Sample use case

See what remains unresolved.

A useful discovery tool should not turn uncertainty into false precision. ELSii can preserve whether a relationship is strongly supported, relies on fallback logic, remains unresolved or needs targeted review.

ResolvedEvidenceRelationships supported by source structure, runtime evidence and the resolved semantic context.
ReviewFallbackRelationships where useful evidence exists but targeted engineering review may still be appropriate.
UnresolvedVisibleGaps remain explicit rather than being silently converted into a confident-looking lineage arrow.
ELSii speed

What does that look like in practice?

Indicative timings from ELSii development testing on a laptop (2GHz, 32GB RAM), using flows of increasing size and complexity.

Flow 1 · 1 job42 code lines14 seconds3 tables · 16 columns
Flow 7 · 8 jobs982 code lines73 seconds62 tables · 313 columns
Flow 18 · 1 job3,809 code lines19 minutes246 tables · 4,768 columns

Development benchmark results only; processing time will vary with code complexity, environment and available execution evidence.

Validation

Built to be tested.

ELSii currently has around 230 component test scripts for automated, repeatable testing. The test framework runs targeted SAS cases through the pipeline and audits the results so passes, mismatches, diagnostics and unresolved behaviour remain visible.

The audit is deliberately not a green-tick marketing screen. When a component needs investigation, the dashboard shows it. That makes coverage and accuracy something that can be measured and improved rather than simply claimed.

ELSii Active Component AuditRepresentative view of an active test batch
Outcome: INVESTIGATE
Tests7
Pass rows1661
Fail rows13
Framework errors0
Tests · 3 issuesRunner · 0 issuesLog Audit · 3 issuesArtifacts · 0 issues
TestStatusTargetELSii pipeline
CORE_C4_005PASS0.0s16.9s
CORE_C4_006PASS0.1s15.7s
component checkREVIEW—evidence retained
Migration context

Understand the logic before migration. Validate the result afterwards.

ELSii maps the existing SAS estate — its lineage, calculations and dependencies — so teams know what must be carried forward. Regression testing then checks whether the migrated implementation produces the expected output. Together they support understanding before migration and validation after it.

Migration stageHow ELSii can help
BeforeDiscover dependencies, scope the estate and identify business logic
DuringCapture transformations, calculations and the dependencies that must be preserved
ValidationTrace mismatches back through the lineage to the relevant source logic
Demo

Want to see ELSii against a real SAS process?

A short demo can cover the surface view; a longer session can go into the lineage model and technical detail.