Engrafo SAS Analyzer
With Engrafo SAS Analyzer you can In 2 simple steps document all your SAS/Base and EG programs, giving you:
- A complete data catalog of all the data used in all your programs
- A one source of truth to view all program and table dependencies
- A complete interactive data lineage diagram with underlying data for impact analysis
- A way to automatically publish and maintain SAS program documentation
- Statistics on data step, procedures, and program runtimes
- Lineage diagrams between tables and SAS programs
- Possibility to switch between a logic representation(libnames) and pysical representations(path-representation)
- Flowcharts for all programs are generated and stored as .svg
- Answers on questions like: Which programs, procedures, data steps require the most time to execute? Where are the bottlenecks?
- Which libnames are being used and how intense is the usage? Are we using any locale libnames?
- What are the inputs and outputs data for specific steps in a program
- And much more...
To automatically generate lineage, data catalog, and more we need the output from the procedure proc scaproc
This is quite easily done by encapsulating your program with the below statements:
Surely you can find a good way to submit this code pre and post each program... Otherwise we have some snippets/macros' for this. You only want to do this once 😉
Login and upload all your logs for analysis and let Engrafo do the hard work
(get your login by sending a mail to contact@engrafo.dk)
Browse the data catalog and data usages to get information like:
data catalog, data lineage, program flowchart, runtimes, and other relevant documentation about your SAS programs