https://communities.sas.com/t5/New-SAS-User/How-to-solve-EG-duplicate-librefs-detected/m-p/543391#M7699 Hi Unfortunately I am the administrator for clients who use sas eg. I won't know if who has created the duplicate libref nor if the libref is speficially required or can be removed. Is there an easy way to handle this issue Fri, 15 Mar 2019 03:02:12 GMT c4th1 2019-03-15T03:02:12Z https://communities.sas.com/t5/New-SAS-User/How-to-solve-EG-duplicate-librefs-detected/m-p/543380#M7693 Hi, in the old discussion (<A href="https://communities.sas.com/t5/Administration-and-Deployment/SAS-EG-library-issue/m-p/312491" target="_blank">https://communities.sas.com/t5/Administration-and-Deployment/SAS-EG-library-issue/m-p/312491</A>), there was a discussion on multiple libraries were detected in metadata that use the same libref for server sasappva. this is not a supported configuration and may cause problems. can i please ask what should i do after i found the the libraries that have duplicate librefs? thank you. regards c4th1 Fri, 15 Mar 2019 01:27:39 GMT https://communities.sas.com/t5/New-SAS-User/How-to-solve-EG-duplicate-librefs-detected/m-p/543380#M7693 c4th1 2019-03-15T01:27:39Z https://communities.sas.com/t5/New-SAS-User/How-to-solve-EG-duplicate-librefs-detected/m-p/543382#M7695 <P>Follow the instructions in the linked discussions's answered post to remove duplicate LIBREFs.</P> Fri, 15 Mar 2019 01:51:42 GMT https://communities.sas.com/t5/New-SAS-User/How-to-solve-EG-duplicate-librefs-detected/m-p/543382#M7695 SASKiwi 2019-03-15T01:51:42Z https://communities.sas.com/t5/New-SAS-User/How-to-solve-EG-duplicate-librefs-detected/m-p/543391#M7699 Hi Unfortunately I am the administrator for clients who use sas eg. I won't know if who has created the duplicate libref nor if the libref is speficially required or can be removed. Is there an easy way to handle this issue Fri, 15 Mar 2019 03:02:12 GMT https://communities.sas.com/t5/New-SAS-User/How-to-solve-EG-duplicate-librefs-detected/m-p/543391#M7699 c4th1 2019-03-15T03:02:12Z https://communities.sas.com/t5/New-SAS-User/How-to-solve-EG-duplicate-librefs-detected/m-p/543396#M7700 <P>These are metadata-defined LIBREFs only so they have to have been created in SMC. How many users have access to SMC to do this? In any case disabling the duplicates will give you the chance to identify who is using these as no doubt they will come and complain to you...</P> Fri, 15 Mar 2019 03:27:23 GMT https://communities.sas.com/t5/New-SAS-User/How-to-solve-EG-duplicate-librefs-detected/m-p/543396#M7700 SASKiwi 2019-03-15T03:27:23Z https://communities.sas.com/t5/New-SAS-User/How-to-solve-EG-duplicate-librefs-detected/m-p/543419#M7706 <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/158456">@c4th1</a>&nbsp;wrote:<BR />Hi Unfortunately I am the administrator for clients who use sas eg. I won't know if who has created the duplicate libref nor if the libref is speficially required or can be removed. Is there an easy way to handle this issue<HR /></BLOCKQUOTE> <P>For this reason, I have disabled "normal" users capability to define metadata librefs. If users need to access special directories, they can write a libname in the code, but they don't need to clutter up the metadata.</P> <P>And if global access is needed, they have to contact one of the admins to do it.</P> Fri, 15 Mar 2019 06:46:49 GMT https://communities.sas.com/t5/New-SAS-User/How-to-solve-EG-duplicate-librefs-detected/m-p/543419#M7706 Kurt_Bremser 2019-03-15T06:46:49Z https://communities.sas.com/t5/New-SAS-User/How-to-solve-EG-duplicate-librefs-detected/m-p/843260#M36585 <P>For those who finds this track searching for how to identify and eliminate duplicate librefs in SAS 9 metadata, here is a blog post that addresses this in detail:</P> <H1 class="post-title item fn"><A href="https://blogs.sas.com/content/sgf/2022/11/08/sas-administrator-tip-how-to-identify-and-prevent-duplicate-librefs-in-sas-metadata/#:~:text=Identifying%20duplicate%20LIBREFs%20in%20SAS%20Metadata%201%20SAS,your%20interest.%20...%203%20Duplicate%20librefs%20output%20" target="_self">SAS administrator tip: How to identify and prevent duplicate librefs in SAS metadata</A></H1> <P>&nbsp;</P> <P>It also presents a solution on how to prevent duplicate librefs in SAS metadata.</P> Tue, 08 Nov 2022 23:59:09 GMT https://communities.sas.com/t5/New-SAS-User/How-to-solve-EG-duplicate-librefs-detected/m-p/843260#M36585 LeonidBatkhan 2022-11-08T23:59:09Z