Hi Tim,
I am trying to get the list of folders, subfolders and the files in it. Don't have Dis. is it possible for me to get those information form SMC. If so, How can i do that?
Thanks
One way you can do it albeit indirectly is via the SAS Security macros. It will give out a list of folders and the permissions of each group, It's an autocall so just run %mdsecds; You will get a bunch of datasets in work. The view mdsecds_join will show the folders.
In your prompt populate the prompt from data in these datasets. you will also get the metadata id. You will then need to write some logic to issue an addMetadata/UpdateMetadata call as well to get the table information into the repository.
Hi,
I am going to try this. Will let you know the result.
Thanks
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.
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.