topic Re: Some of SAS EG datasets are not visible in SAS Enterprise Guide

Some of SAS EG datasets are not visible

Riana — Tue, 20 Sep 2016 08:18:03 GMT

Hi,

I'm using Impala connector in SAS EG to connect to the data sources and after running the libname it shows a list of databases under "Libraries" folder.

But when I check source databases in Hue/Impala and compare them with databases in SAS EG, it seems that some of them are visible in SAS EG and not visible in Hue/Impala and vice versa. Why this happens?

Thanks.

Re: Some of SAS EG datasets are not visible

Reeza — Tue, 20 Sep 2016 08:53:49 GMT

The not visible datasets, what is the length of dataset name? Is it over 32 chars?

Re: Some of SAS EG datasets are not visible

Riana — Tue, 20 Sep 2016 10:31:14 GMT

Yes. it is about 39 chars.

Re: Some of SAS EG datasets are not visible

Kurt_Bremser — Tue, 20 Sep 2016 10:55:34 GMT

So at least part of your problem is that there are table names in the Impala database that exceed the maximum length of SAS dataset names (32).

Re: Some of SAS EG datasets are not visible

Riana — Tue, 20 Sep 2016 13:50:16 GMT

Thank you Reeza and KurtBremser.

Yes, those datasets that are not visible have more than 32 chars for the lenght of dataset name.

Re: Some of SAS EG datasets are not visible

CaseySmith — Tue, 20 Sep 2016 17:02:04 GMT

Here is SAS documentation for the naming conventions for Impala:

http://support.sas.com/documentation/cdl/en/acreldb/69039/HTML/default/viewer.htm#n0zbh5w5ucvt2gn1t1gnpm6e0sl3.htm

...confirming "DBMS table names must be 32 characters or less. SAS does not truncate a name longer than 32 characters. If you have a table name that is greater than 32 characters, it is recommended that you create a table view."