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?
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
Thank you Bruno.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.