BookmarkSubscribeRSS Feed
borissoudler
Calcite | Level 5

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?

 

2 REPLIES 2
BrunoMueller
SAS Super FREQ

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

borissoudler
Calcite | Level 5

Thank you Bruno.

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1551 views
  • 1 like
  • 2 in conversation