not all registered tables show up in assigned library

[okaka23]

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.

[ChrisBrooks]

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

[SASKiwi]

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.

[ASHISH2525]

Hi,

Did you find any solution for this.

We are facing same issue.

Regard,

Ashish

[SASKiwi]

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.