topic Registering Table with metadata in SAS Enterprise Guide

Registering Table with metadata

Tushar — Wed, 06 Feb 2013 13:08:14 GMT

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#n1u5wrckqyafv0n11skke9w5xyui.htm

Please help on this, Thanks in Advanced.

Regards,

Tushar Jagtap.

Re: Registering Table with metadata

ChrisHemedinger — Wed, 06 Feb 2013 13:23:20 GMT

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

Re: Registering Table with metadata

Tushar — Wed, 06 Feb 2013 13:32:54 GMT

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?

Re: Registering Table with metadata

ChrisHemedinger — Wed, 06 Feb 2013 13:37:22 GMT

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 Dummy

Chris

Re: Registering Table with metadata

Tushar — Wed, 06 Feb 2013 13:43:39 GMT

Awesome.. Thats i wanted.

Thanks a lot chris..