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.
... View more