Desktop productivity for business analysts and programmers

pre-assigned libraries and retaining metadata when joining tables

Reply
Occasional Contributor
Posts: 15

pre-assigned libraries and retaining metadata when joining tables

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
Trusted Advisor
Posts: 1,050

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

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