WEBVTT

00:00:00.000 --> 00:00:03.000
From a reporting program to one report definition.

00:00:03.000 --> 00:00:08.000
The 100-line SAS program reads inputs and prepares reporting data.

00:00:08.000 --> 00:00:13.000
Procedural sheet setup writes Summary, Detail and Exceptions.

00:00:13.000 --> 00:00:19.000
DRE names the queries and sheets. Business rules stay in database SQL.

00:00:19.000 --> 00:00:26.000
One 34-line YAML definition produces a styled workbook and fills an Excel template.

00:00:26.000 --> 00:00:38.000
Real Oracle run. Keyed checks pass: 8 detail accounts, AUD 3,480.01, both workbooks.

00:00:38.000 --> 00:00:47.000
The generated workbook, opened in Microsoft Excel. Formatting comes from YAML.

00:00:47.000 --> 00:00:57.000
The Excel-authored template, opened in Microsoft Excel. Both outputs pass the same checks.

00:00:57.000 --> 00:01:01.000
Inspect the SQL and YAML. Download the project.