topic Re: CREATE SAS Metadata Folder Structure from Excel in SAS Data Management

CREATE SAS Metadata Folder Structure from Excel

sanalitics — Wed, 01 Aug 2018 06:59:50 GMT

Hi All,

Kindly let me know if there is an automation process/procedure that could be used to create the metadata folder from the folder structure saved in EXCEL...

Thanks,

Sandeep

Re: CREATE SAS Metadata Folder Structure from Excel

Kurt_Bremser — Wed, 01 Aug 2018 07:51:33 GMT

The proper way to export/import metadata structures is to create SAS packages with Management Console.

I would only try to manipulate the metadata with an Excel source if

I had a strong masochistic streak
I had too much time at hand
I had a good backup

As it is, I only have the third item.

Re: CREATE SAS Metadata Folder Structure from Excel

sanalitics — Wed, 01 Aug 2018 08:07:07 GMT

Hi Kurt,

Thanks for the reply. But what I need to know is if there is way to automate where we have created all the folder structure and hierarchy in an excel and instead of creating the metadata folder structure manually in DI or SMC.. I want to know a method which could help me copy the same structure as in EXCEL.

Re: CREATE SAS Metadata Folder Structure from Excel

SASKiwi — Wed, 01 Aug 2018 08:11:59 GMT

I'm in total agreement with @Kurt_Bremser.

If you need any further confirmation of the complexities of SAS metadata read on:

http://documentation.sas.com/?docsetId=omaref&docsetTarget=maincontents.htm&docsetVersion=9.4&locale=en

And then agree with us that there are better things to do than building your own metadata interface tool...

Re: CREATE SAS Metadata Folder Structure from Excel

Kurt_Bremser — Wed, 01 Aug 2018 08:17:08 GMT

Why, in $DEITY's name, do you create the folder structure in Excel? That's just a colossal waste of time. The tool for this is the Management Console. Just look at the Authorization tab of one folder and see how you represent that reliably in Excel, followed by code to get that into SAS without destroying your folder structure (up to the point where it crashes the metadata server).

Just follow the link provided by @SASKiwi to get an idea of the work that awaits you.

Using any other tool than the SMC only makes sense if you have a very good understanding of the internal works of the SAS metadata. (eg you are working in Cary, NC).

Re: CREATE SAS Metadata Folder Structure from Excel

Patrick — Thu, 02 Aug 2018 07:49:19 GMT

@sanalitics

It could be done but I'm not aware of any ready-to-use code for it and though you would have to write this code yourself.

The metadata API is not very "user-friendly" and it would be quite a bit of work to implement something robust where you don't risk to corrupt metadata.

For this reason: If this is about getting the job done then I'd only consider something like this for 200+ folders. Else: Use SMC or DIS and do it manually. That's going to be faster and safer.

Re: CREATE SAS Metadata Folder Structure from Excel

AllanBowe — Fri, 21 May 2021 18:48:25 GMT

It's possible, you could create a stored process or even upload your excel to a web application and run this macro:

%mm_createfolder(path=/some/meta/folder)

We use it in our automated builds for Data Controller. The Viya version of the macro is here.