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,
Please help on this, Thanks in Advanced.
Regards,
Tushar Jagtap.
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
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
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?
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:
Chris
Awesome.. Thats i wanted.
Thanks a lot chris..
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: