topic Re: not all registered tables show up in assigned library in SAS Enterprise Guide

not all registered tables show up in assigned library

okaka23 — Thu, 20 Dec 2018 16:47:26 GMT

I am using SAS EG and assign library 'US' as libname US ODBC user=XXX using=XXX datasrc=PROD_CBA schema=US

I should have permission to 10 tables in US library, table1, table2, table3....table10. However, when I expand US library, it shows only table1 to table5.

But I still have access to table6... table10 , they are just not visible in the library.

I got the output after running the codes below.

data test;

set table7 (obs=5);

run;

I have also try uppercase of the the schema, but it doesn't help.

there's probably an OPTIONS statement we can use to avoid this issue but really cannot recall it. Thanks for the help.

Re: not all registered tables show up in assigned library

ChrisBrooks — Fri, 21 Dec 2018 00:03:13 GMT

I see you're using an ODBC driver - what is the data source e.g. ORACLE, MySQL?

Re: not all registered tables show up in assigned library

SASKiwi — Fri, 21 Dec 2018 20:55:58 GMT

Are table1, table2 etc the actual table names? The reason I ask is table names longer than 32 characters won't show as this is a documented SAS limitation.

Re: not all registered tables show up in assigned library

ASHISH2525 — Sat, 07 Sep 2019 08:27:13 GMT

Hi,

Did you find any solution for this.

We are facing same issue.

Regard,

Ashish

Re: not all registered tables show up in assigned library

SASKiwi — Sat, 07 Sep 2019 22:40:35 GMT

If you are setting up a data source to an external database in SAS metadata in SAS Management Console, then to ensure you can see tables add AssignMode = 2 in the Properties of the library.

This also avoids having to register the tables in the first place.