08-24-2016 12:33 PM
I have SAS 9.3 Data Integration Studio. I have a task to produce a report on source and target tables/columns for the list of source table names. For example, if I have source table ST1 with columns ST1C1, ST1C2, ST1C3 and this table is used to create table J1TT1 with columns J1TT1C1, J1TT1C2, J1TT1C3 in Job1 and the same table is used to create another table J2TT1 with columns J2TT1C1, J2TT1C2, J2TT1C3 in Job2 and my report should be as follows. I can get this information in SAS DI Studio by right click on Analyze and then Analyze columns (i.e, Impact analysis of table/column) but not in table report format. I need the result in table format as follows. Could someone please help on this?
Source_Table Source_Column Target Table Target Column
ST1 ST1C1 J1TT1 J1TT1C1
ST1 ST1C2 J1TT1 J1TT1C2
ST1 ST1C3 J1TT1 J1TT1C3
ST1 ST1C1 J2TT1 J2TT1C1
ST1 ST1C2 J2TT1 J2TT1C2
ST1 ST1C3 J2TT1 J2TT1C3
08-25-2016 02:29 AM
Have you thought of trying the Relationship Report in the $SASHOME/SASPlatformObjectFramework folder?
The documentation is in the SAS 9.4 Intelligence Platform: System Administration Guide.
08-25-2016 06:25 AM
Hi AndrewHowell, Thanks for your response. I have SAS 9.3 and looks like Relationship Report Facility is not available in SAS 9.3. Could you please let me know any other way to produce the required report in SAS 9.3
08-26-2016 01:00 AM
Ok, I haven't had access to a 9.3 platform for some time now, so I can only go by the equivalent SAS 9.3 online documentation..
So it looks like the same batch-file functionality doesn't exist in v9.3.
However, there is still the possibility of constructing your own metadata lineage report by running either XML requests, or SAS-coded metadata calls to find the attributes/associations of specific fields in specific tables.
Documentation is in the SAS(R) 9.3 Language Interfaces to Metadata
Hope that helps..
08-31-2016 04:16 AM
I have tried with PROC METALIB but could not able to achieve the column impact analysis (available in DI) in program mode using PROC METALIB to get the results.