Columns level analysis

[VVDR]

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

[AllanBowe]

Hi VVDR,

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

1. 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)
2. Use SAS Lineage (will show one layer of lineage at a time)
3. 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