topic Re: Metadata location in SAS Programming

Metadata location

borissoudler — Thu, 08 Oct 2015 14:10:18 GMT

Hi experts,

I'm looking the way to get full Metadata path for specific report in SAS code.

For example: The full path for Sample: European Demographic Data Detail is : /Products/SAS Intelligence Platform/Samples

Is it possible?

Re: Metadata location

BrunoMueller — Fri, 09 Oct 2015 11:58:24 GMT

Have a look at the %MDSECDS macro, it will extract the data you are interested. Since it is a SAS Macro, the source code is available.

To get all Stored Processes your user can read run this this code. Provided you have a connection to a Metadata Server.

%mdsecds(
  membertypes="StoredProcess"
)

It will create several SAS data Sets and a view. The WORK.MDSECDS_OBJS will contain all the Stored Processes with their folder location. You can the use the a WHERE statement to just get the one Stored Process you are interested.

Check the %MDSECDS documentation, there is also a MEMBERFILTER parameter.

Bruno

Re: Metadata location

borissoudler — Sun, 11 Oct 2015 06:56:07 GMT

Thank you Bruno.