topic Re: Removing SAS metadata associations in SAS Programming

Removing SAS metadata associations

ErikLund_Jensen — Sat, 05 Jan 2019 13:50:47 GMT

Hi community friends

I have a problem with SAS metadata, and I don't know how to solve it.

We have a large structure with about 3000 folders under the SAS Data Integration Studio Custom Tree. We wanted to associate about 300 third-level folders with an owner and then let then value be inherited to subfolders in reporting only, but a misunderstanding caused the owners to be set on all subfolders as well.

Now I want to remove owners from all subfolders, but I have not figured out how to do it without removing all associations of a given type and the associated objects as well (metadata-delassn function).

This is the association structure (objects are capitalized):
TREE- ResponsibleParties - RESPONSIBLEPARTY - Persons - PERSON

The problem is that I must delete the ResponsibleParties-association between a Tree-object and a ResponsibleParty-object with the role Owner. We could live with removing all ResponsibleParties-associations for a given object, but deleting the ResponsibleParty-object itself must be avoided, because it is used in many associations besides the one to be deleted. Any help will be appreciated!

Re: Removing SAS metadata associations

Sajid01 — Sun, 06 Jan 2019 17:12:43 GMT

I have not worked with DI studio, however based on my experience with folders on a BI server have a suggestion. Perhaps the information I give may be of help.
In BI server the metadata folders can be exported as a package and imported.

Similarly in the DI studio one should be able to rearrange folders

( http://support.sas.com/documentation/cdl/en/etlug/68225/HTML/default/viewer.htm#n0qdpe8ffsg8w9n1d7svdr3ox46w.htm )

With this information one can create 1. new subfolders 2.Copy the contents from the older ones'(one approach is to export and import) 3) set new properties.

If this works, the old folders can be given a new name and the new folder can be given the name of old folders.

Re: Removing SAS metadata associations

ErikLund_Jensen — Mon, 07 Jan 2019 11:03:49 GMT

Hi Somename

Thanks for your suggestion. I was working on it, but a technical consultant from SAS Institute, who happened to be at my work today, thougt it might ruin our securitybased on access control templates on folders, and found out that the metadata_setassn can be used with a remove option and do what I want, even if the metadata_delassn cannot.