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 ?
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.
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!