topic A problem about get SAS library defined by MC in SAS Enterprise Guide

A problem about get SAS library defined by MC

Slash — Sun, 18 Aug 2013 11:52:56 GMT

Hi, guys.

I am using C# to develop my own SAS client, a problem came out when I get the SAS libraries list. At first, I have already finished to connect to the remote SAS server. Here is the problem:

When I use EG to connect the SAS server, there is 11 libraries, 3 of them is defined in MC. If you want to use them, you must assign them first.

But in my own client, I use the method "ListLibrefs" of SAS.DataService, I can only get 8 libraries, can't get the 3 libraries defined by MC.

And I use the same user to login the SAS server. How to get the libraries defined in MC, and assign them?

Re: A problem about get SAS library defined by MC

TomKari — Sun, 18 Aug 2013 14:09:26 GMT

Very interesting application!

For this one, I suggest you put in a case to SAS Tech Support. If you haven't used them before, they're very good, and I'm sure they'll be able to help you.

Your problem delves into corners of SAS that aren't that heavily used, so I'm not sure the discussion forums will be able to pop up an answer.

Tom

Re: A problem about get SAS library defined by MC

ChrisHemedinger — Sun, 18 Aug 2013 15:06:16 GMT

Those libraries that are defined in metadata and shown in white in EG - they are "potential" libraries. They have definitions in SAS metadata but they are not assigned.

To assign them, you would use a LIBNAME statement or an AssignLibref API call, and use the META engine:

libname month META library="Month Data";

To learn which libraries are available in metadata, you must issue a metadata query. I have a PowerShell example that you can adapt here:

Using Windows PowerShell to find registered tables and columns in SAS metadata - The SAS Dummy

This example discovers "PhysicalTable" objects, but you can issue a similar request for SASLibrary objects. You might find a PROC METADATA example that shows the metadata query that you need.

Chris

Re: A problem about get SAS library defined by MC

Slash — Mon, 19 Aug 2013 01:35:53 GMT

Thanks!

Re: A problem about get SAS library defined by MC

Slash — Mon, 19 Aug 2013 02:04:42 GMT

Thanks, Chris!

Actually, I read your blog "Build your own SAS client app with Microsoft .NET" recently, and I started to build my own client.

So I believe there are lots of problems I'm gonna ask you.