topic Re: How to identify impact of changing stored process name? in Administration and Deployment

How to identify impact of changing stored process name?

f_rederik — Fri, 07 Dec 2018 07:26:10 GMT

We have a number of Stored Processes where the Stored Process name contains a blank space. In many cases also the .sas code file contains spaces.

Is it possible to identify where a Stored Process is used so as to assess impact of removing the blank space? I found some reference to DI Studio being able to do an "Impact Analysis" however this option is not available when right-clicking.

Any pointers as to where I can find more info about this?

Thanks
Frederik

Re: How to identify impact of changing stored process name?

AjmalFarzam — Mon, 10 Dec 2018 01:33:38 GMT

Hi,

I think the 'Reverse Lineage' option in BI Lineage Plug-In is what you're after: https://go.documentation.sas.com/?docsetId=bisag&docsetTarget=p14w0edwch53wdn1fior9hlxo39x.htm&docsetVersion=9.4&locale=en

Re: How to identify impact of changing stored process name?

f_rederik — Mon, 10 Dec 2018 07:30:44 GMT

Great - thanks - will check this out but not sure if I have necessary access..