Desktop productivity for business analysts and programmers

Some of SAS EG datasets are not visible

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 81
Accepted Solution

Some of SAS EG datasets are not visible

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.

 

 


Accepted Solutions
Solution
‎09-20-2016 09:46 AM
Esteemed Advisor
Posts: 6,698

Re: Some of SAS EG datasets are not visible

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).

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers

View solution in original post


All Replies
Grand Advisor
Posts: 17,427

Re: Some of SAS EG datasets are not visible

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

Frequent Contributor
Posts: 81

Re: Some of SAS EG datasets are not visible

Yes. it is about 39 chars.

Solution
‎09-20-2016 09:46 AM
Esteemed Advisor
Posts: 6,698

Re: Some of SAS EG datasets are not visible

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).

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Frequent Contributor
Posts: 81

Re: Some of SAS EG datasets are not visible

Thank you Reeza and KurtBremser. 

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

 

SAS Super FREQ
Posts: 273

Re: Some of SAS EG datasets are not visible

Here is SAS documentation for the naming conventions for Impala:

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

 

...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."

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 5 replies
  • 426 views
  • 0 likes
  • 4 in conversation