Desktop productivity for business analysts and programmers

How to retain formats / labels in the query window

Reply
Occasional Contributor
Posts: 15

How to retain formats / labels in the query window

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
Respected Advisor
Posts: 4,137

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

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
Occasional Contributor
Posts: 15

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

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
Ask a Question
Discussion stats
  • 2 replies
  • 114 views
  • 0 likes
  • 2 in conversation