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
... View more