SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

CREATE SAS Metadata Folder Structure from Excel

Reply
Contributor
Posts: 21

CREATE SAS Metadata Folder Structure from Excel

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

 

Super User
Posts: 10,589

Re: CREATE SAS Metadata Folder Structure from Excel

Posted in reply to sanalitics

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

  1. I had a strong masochistic streak
  2. I had too much time at hand
  3. I had a good backup

As it is, I only have the third item.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Contributor
Posts: 21

Re: CREATE SAS Metadata Folder Structure from Excel

Posted in reply to KurtBremser

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.

Super User
Posts: 10,589

Re: CREATE SAS Metadata Folder Structure from Excel

Posted in reply to sanalitics

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).

 

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Respected Advisor
Posts: 4,797

Re: CREATE SAS Metadata Folder Structure from Excel

Posted in reply to sanalitics

@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. 

Super User
Posts: 4,026

Re: CREATE SAS Metadata Folder Structure from Excel

Posted in reply to sanalitics

I'm in total agreement with @KurtBremser.

 

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...

 

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

Ask a Question
Discussion stats
  • 5 replies
  • 155 views
  • 5 likes
  • 4 in conversation