How do output metadata folder and objects into a SAS table

Reply
Regular Contributor
Posts: 152

How do output metadata folder and objects into a SAS table

[ Edited ]

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.

Trusted Advisor
Posts: 1,128

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

[ Edited ]

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

Thanks,
Jag
Respected Advisor
Posts: 3,889

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

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

Regular Contributor
Posts: 152

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

HI I modified my question. sorry for making it unclear
SAS Super FREQ
Posts: 683

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

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.

 

Ask a Question
Discussion stats
  • 4 replies
  • 118 views
  • 1 like
  • 4 in conversation