SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

SAS DI Studio Impact Analysis View in table format

Reply
New Contributor
Posts: 3

SAS DI Studio Impact Analysis View in table format

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  

 

 

Moderator
Posts: 238

Re: SAS DI Studio Impact Analysis View in table format

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.

New Contributor
Posts: 3

Re: SAS DI Studio Impact Analysis View in table format

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

Moderator
Posts: 238

Re: SAS DI Studio Impact Analysis View in table format

Upgrade? (Sorry, couldn't resist..)
Moderator
Posts: 238

Re: SAS DI Studio Impact Analysis View in table format

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

 

Regards,

Andrew.

New Contributor
Posts: 3

Re: SAS DI Studio Impact Analysis View in table format

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.

Ask a Question
Discussion stats
  • 5 replies
  • 343 views
  • 1 like
  • 2 in conversation