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.
are you asking about comparing the dictionary.columns with dictionary.tables or sashelp.vcolumns with sashelp.vtables.
"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?
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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.