How do output metadata folder and objects into a SAS table

[gyambqt]

Hi Experts,

I have a list of DI jobs stored in different metadata folder. I want to compare the name of the DI objects with metadata folder name.

for example,  I can have DI job called 001_job1 and 002_job2 and both jobs are stored as metadata object in metadata folder called 000_folder

My question is how do I export or retrieve the name of each DI objects and it's corresponding metadata folder name?

the output can be like:

metadata_folder             DI job

000_folder                      001_job1

000_folder                     002_job2

Thanks.

[Jagadishkatam]

are you asking about comparing the dictionary.columns with dictionary.tables or sashelp.vcolumns with sashelp.vtables.

[Patrick]

@gyambqt

"compare the metadata object  name with its metadata folder name"

What do you want to compare? If a metadata object has the same name than it's containing metadata folder? And what kind of metadata objects are you talking about?

[gyambqt]

HI I modified my question. sorry for making it unclear

[BrunoMueller]

Hi

You can use the sas-list-objects batch tool to list all the job and their corresponding folder, like so:

...\SASHome\SASPlatformObjectFramework\9.4\tools>sas-list-objects.exe -host someName -port 8561 -user yourUser -password yourPassword -types Job -format csv > c:\temp\joblist.csv

Another way of doing it would be using the %MDSECDS macro like so:

%mdsecds(memberTypes="Job")

Using this method, you already have all the information as a SAS data set.