Maintain or repair stored process relationships in EG and AMO after moving a stored process

ICI_SAS_Admins — Fri, 20 Nov 2015 19:36:58 GMT

We have a library of SAS stored processes registered in SAS folders. The current storage methodology has become cluttered and unmanageable. We would like to implement a new organization structure for the SAS folders. We are able to export a SAS package, delete the original stored processes and then import the SAS package into the new SAS folder. However, after doing this, any references to the original stored process in Enterprise Guide projects or SAS Add-in for Microsoft Office files generate an error message. It appears that even trying to change the name of the stored process without moving to a new SAS folder also causes errors. This leads me to believe that the reference to the stored process that is stored in the EG projects and the SAS AMO files is a text reference to the pathed location of the SAS object (in this case a stored process).

I know that every object in the SAS metadata has a unique id. Is there a way to link the stored process to the EG project or AMO file by this id rater than by name and location? Is there some other way that I can maintain a functioning link to a stored process, but still have flexibility to move it to a new SAS folder and/or change the name?

--Shaun

Re: Maintain or repair stored process relationships in EG and AMO after moving a stored process

Quentin — Fri, 20 Nov 2015 20:14:07 GMT

Interesting question.

It's possible to read the metadata to look up the stored process name that is refernced by the Unique ID, and get the stored process name and metadata location. Perhaps something close to what you want would be a custom task that, in EG, lets you input a UID, and then the task looks up the stored process and opens it in the current project.

It still wouldn't be a link that uses the UID (I have definitely had situations where that would be a nice feature), but it would at least make it easier to reestablish links that were broken when a stored process is moved/renamed. Just a thought.

You might get more thoughts on the feasibility of a custom task approach if you post this in the EG group.

You could also submit the UID link idea as a feature request.

topic Re: Maintain or repair stored process relationships in EG and AMO after moving a stored process in Developers

Maintain or repair stored process relationships in EG and AMO after moving a stored process

Re: Maintain or repair stored process relationships in EG and AMO after moving a stored process