Creating a metadata table of an existing sas table

[vickys]

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

[r_behata · Accepted solution]

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.

[Patrick]

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.