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.
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
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.
Ready to level-up your skills? Choose your own adventure.