topic Re: How to retain formats / labels in the query window in SAS Enterprise Guide

How to retain formats / labels in the query window

Ebele — Wed, 27 Apr 2011 09:31:27 GMT

Hi,
I have registered SQL Server tables in the metadata.
In the registered metadata, I have changed some attributes like column formats and column descriptions. Attributes which cannot be stored in the SQL server table.

When I query the table using the query builder in EG 4.3 through a library assigned with metadata libname engine,
the formats / labels are not retained to the resulting table.

Is there a way to achieve this ?

Thanks,
Ebele

Re: How to retain formats / labels in the query window

Patrick — Wed, 27 Apr 2011 10:49:30 GMT

Hi

The library needs to be pre-assigned in order for table metadata to be used.

Eventually you could add option "defer=yes" to the metadata library definition so the connection to the database will only be established when you actually use one of the tables (at least I think this is how it works).

Do NOT use "defer=yes" if this is an OLEDB connection: http://support.sas.com/kb/41/581.html

HTH
Patrick

Re: How to retain formats / labels in the query window

Ebele — Wed, 27 Apr 2011 12:02:15 GMT

Hi Patrick... yes, that's it!
I thought using the meta engine would be enough, but you also need to pre-assign it.
Thanks a lot.
Ebele