How to register tables to register on UNIX platforms using SASMC?

[Mushtaq]

After creating datasets (tables) in SAS 9.3 , I want to register them in a SAS Metadata Repository. But in SASMC, the Register Tables wizard is not available.

Environment ManagementData Library ManagerLibraries.

The "Register Tables" wizard window does not appear.

Is there any alternative?.

[Kurt_Bremser]

Did you right-click on a library?

[MikeMcKiernan]

The register tables wizard was exclusive to SAS Management Console on Windows for a very long time.  In the SAS 9.4 release, support for Linux was added.  Only Linux is added, Solaris and other operating systems were not added. I want to say that support for Linux is available as a hot fix to the second maintenance release of SAS 9.3.  However, I'm having trouble finding that information, I don't work with hot fixes often.

One alternative is to use the METALIB procedure.

There is some information in the SAS(R) 9.3 Intelligence Platform: Data Administration Guide, Second Edition

Information about the METALIB procedure is available in the SAS(R) 9.3 Language Interfaces to Metadata

[ronan · Accepted solution]

The absence of this Register Tables Wizard was one of the very few differences between Unix and Windows versions of the SMC. Great to have this feature now available on Linux 9.4 !

@Mushtaq : apart from the MetaLib procedure (BTW, you might be able to code a user-friendly wizard yoursel based on Metalib code executed by a Stored Process with dynamic Prompt), the ETL client SAS Data Integration Studio also provides the table registering assistant.

[Mushtaq]

Thank you Ronan,

I used proc metalib and got it done on SAS 9.3. But I do not know how to covert the code into stored process.

Yes, I noticed  SAS 9.4 M2 offers the tap "Register tables"  on Linux sasmc.

[ronan]

Hi Mushtaq,

You are welcome. In order to create a stored process that does the same job, (almost) no SAS coding skills are required. Only SAS Enterprise Guide.

For instance, you can generate your own SAS synchonrisation code (Proc Metalib)  using SAS Enterprise Guide  Tools / Update Metadata then Right-Click on the node & Modify tasks.

Then with another option in the same menu, you can Create a Stored process with your SAS job. The assistant shall guide you in the forthcoming steps.

To give the final touch, add a cascading Prompt to your Stored Process that will create a Table selection filed based on the Tables to be updated in metadata for the given Library.

SAS Data Integration Studio provides the same facility:  you can generate a SAS Stored Process with your ETL job but I personally don't favor this kind of usage rather far-fetched.

[jakarman]

Mike as you say the smc for Linux I think you indicating the one that is installed on Linux to be accessed using x11 for the graphical intetface.

The smc on Windows always could connect to a met as ever running on any operating system serving with wizards to all.

As the smc is a java application it could be a copy deploy only approach avoiding all kind of Windows install issues (needing admin rights). As it is java and using java classes it should be able to run on any operating system. That was the intention of Sun.

Using the x11 at Unix is posing other issues as Unix system administrators do not like graphical approaches eliminating as much as possible they can. To start a process like that you need something like KDE or at least a unix shell.