topic Re: How do output metadata folder and objects into a SAS table in SAS Programming

How do output metadata folder and objects into a SAS table

gyambqt — Tue, 16 May 2017 04:09:41 GMT

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.

Re: How do output metadata folder and objects into a SAS table

Jagadishkatam — Tue, 16 May 2017 03:21:53 GMT

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

Re: How do output metadata folder and objects into a SAS table

Patrick — Tue, 16 May 2017 03:51:21 GMT

@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?

Re: How do output metadata folder and objects into a SAS table

gyambqt — Tue, 16 May 2017 04:10:05 GMT

HI I modified my question. sorry for making it unclear

Re: How do output metadata folder and objects into a SAS table

BrunoMueller — Tue, 16 May 2017 07:37:34 GMT

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.