Columns level analysis

VVDR — Mon, 23 Aug 2021 01:22:40 GMT

Hi All,

Can we do a column level reverse impact analysis in SAS DI.

In our current environment, data flows from 1)Source, 2)base and then to 3)final layer.

In every layer, there are multiple DI jobs and transformations happening and derived columns used.

Now, in the final layer there are few columns and our business wants to see from which table these columns are coming from - is it 1)Source that column got derived/used and the same with 2)base layer.

Do we have any column level impact/reverse analysis option in SAS ?

Thanks

Re: Columns level analysis

AllanBowe — Mon, 23 Aug 2021 09:23:25 GMT

Hi VVDR,

To get the lineage using SAS products you have three options:

Give the business users a copy of Data Integration Studio and ask them to do reverse impact analysis (be sure they have read only metadata rights)
Use SAS Lineage (will show one layer of lineage at a time)
Code your own with Base SAS

There is a fourth option (a plug on my part) - Data Controller for SAS

This provides data lineage with the following benefits:

Works at both Table and Column level
Works both forwards and backwards
Is provided in a browser (great for business users - can link to diagrams)
Lineage queries are cached (great for performance)
Lineage can be exported in PNG, SVG, DOT and CSV formats
Calculations (derived variable definitions) are also displayed
Jobs link to the metabrowse feature
Tables link to the table viewer

Best of all, Data Controller is free for up to 5 users. You can get in touch here: https://datacontroller.io/contact/

More info (videos):
https://docs.datacontroller.io/videos/#data-lineage

topic Re: Columns level analysis in SAS Data Management

Columns level analysis

Re: Columns level analysis