DATA Step, Macro, Functions and more

Metadata location

New Contributor
Posts: 2

Metadata location

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?


Posts: 825

Re: Metadata location

[ Edited ]
Posted in reply to borissoudler

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.


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.



New Contributor
Posts: 2

Re: Metadata location

Posted in reply to Bruno_SAS

Thank you Bruno.

Ask a Question
Discussion stats
  • 2 replies
  • 1 like
  • 2 in conversation