topic Creating a metadata table of an existing sas table in SAS Data Management

Creating a metadata table of an existing sas table

vickys — Fri, 14 Dec 2018 00:25:49 GMT

Hi Guys,

I know its simple but just wondering why the below code in creating the metadata table is creating at database but not in my sas lib.

I ran the following user written code at DI

LIBNAME abc ORACLE;

data abc.want

set abc.have(obs=0);

run;

By this the table is created at database but metadata table is not created at DI.

Could some one let me know why it is not created. or any solution to create a metadata table in SAS DI with user written code.

Many thanks in advance.

Vicks

Re: Creating a metadata table of an existing sas table

r_behata — Fri, 14 Dec 2018 01:32:44 GMT

By default the tables wont be added to the metadata unless there is a separate process to auto refresh the metadata in your environment. The easiest way to update the table metadata would be to right click on the library from the DI and select import tables and then select the table from the list of tables . If you have the right permissions you should be able to add the table metadata to the library.

Re: Creating a metadata table of an existing sas table

Patrick — Sun, 16 Dec 2018 20:23:28 GMT

Just registering the physical table using DIS or SMC is what you normally would do.

If you really need to automate this then you could use Proc Metalib.