05-15-2017 10:15 PM - edited 05-16-2017 12:09 AM
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
05-15-2017 11:21 PM - edited 05-15-2017 11:21 PM
are you asking about comparing the dictionary.columns with dictionary.tables or sashelp.vcolumns with sashelp.vtables.
05-15-2017 11:51 PM
"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?
05-16-2017 03:37 AM
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:
Using this method, you already have all the information as a SAS data set.