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
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
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.