pre-assigned libraries and retaining metadata when joining tables

Ebele — Thu, 09 Jun 2011 13:57:57 GMT

In Enterprise Guide if you query a SQL Server table in a pre-assigned library, the metadata attributes are retained to the resulting output dataset.
But if you join two SQL Server tables, then the metadata attributes are -not- retained to the output dataset.

Is there a way to enforce this ?

Background:
The registered library is pointing to a SQL Server database (via Access to OLEDB).
This library is pre-assigned: in the metadata by the checkmark "Library is pre-assigend" and in the autoexec of the SASAPP server containing this line:
libname cdw meta libid=A5JD5D6P.AZ000010;

On the registered tables in the library we changed some attributes like the label and formats on certain columns.

Thanks,
Ebele

Re: pre-assigned libraries and retaining metadata when joining tables

TomKari — Fri, 10 Jun 2011 00:38:48 GMT

This looks like the same problem we have. If it is, SAS Tech Support has confirmed that this is how it works. We find it quite irritating, and have requested that SAS makes it a priority to remedy the problem.

If it's causing you grief as well, I suggest leaning on SAS as well. The more the merrier!

Tom

topic pre-assigned libraries and retaining metadata when joining tables in SAS Enterprise Guide

pre-assigned libraries and retaining metadata when joining tables

Re: pre-assigned libraries and retaining metadata when joining tables