Desktop productivity for business analysts and programmers

Registering Table with metadata

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 88
Accepted Solution

Registering Table with metadata

Hi all,

Can someone please tell me what all are the way to register Tables with sas-metadata? Suppose i have table in oracle and to access that table, i need to registered that with sas metadata, so one way i know that here i am using SAS DI studio where i can register the table or cubes with metadata using SAS DI studio. somewhere i heard that SAS console Management studio also can do that, so can someone please provide me some help? Also i i have only SAS EG installed on my system so using SAS EG can i registered External Database Table with SAS Metadata? if yes please tell me how? For DI i am using below procedure,

http://support.sas.com/documentation/cdl/en/etlug/62233/HTML/default/viewer.htm#n1u5wrckqyafv0n11skk...

Please help on this, Thanks in Advanced.

Regards,

Tushar Jagtap.


Accepted Solutions
Solution
‎02-06-2013 08:23 AM
Community Manager
Posts: 2,693

Re: Registering Table with metadata

Assuming that you have a SAS library already defined in metadata, you can add registered tables within EG using the Tools->Update Library Metadata task.

If you need to define a new library in metadata, I recommend using SAS Management Console for that task.  It provides the most options and allows you to set up metadata authorizations at the same time.  You can then also register tables from SAS Management Console.

Chris

View solution in original post


All Replies
Solution
‎02-06-2013 08:23 AM
Community Manager
Posts: 2,693

Re: Registering Table with metadata

Assuming that you have a SAS library already defined in metadata, you can add registered tables within EG using the Tools->Update Library Metadata task.

If you need to define a new library in metadata, I recommend using SAS Management Console for that task.  It provides the most options and allows you to set up metadata authorizations at the same time.  You can then also register tables from SAS Management Console.

Chris

Frequent Contributor
Posts: 88

Re: Registering Table with metadata

Thanks Chris for your help, just one more curiosity, i had so want to ask that if i want to go using code and not from wizards so it possible?

I mean how it would have been done if i am using Base SAS IDE? is it even possible using base SAS?

Community Manager
Posts: 2,693

Re: Registering Table with metadata

Tushar,

PROC METALIB is the method you would use.  The task in EG uses PROC METALIB to do its work; you can experiment with that task and see the code that it generates, or you can reference the documentation for METALIB.

If your end users are going to access the data in SAS Enterprise Guide, you might want to read up on this:

What SAS administrators should know about libraries, metadata, and SAS Enterprise Guide - The SAS D...

Chris

Frequent Contributor
Posts: 88

Re: Registering Table with metadata

Awesome.. Thats i wanted.

Thanks a lot chris..

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 949 views
  • 0 likes
  • 2 in conversation