topic Re: Some tables can not be viewed in SAS EG in SAS Enterprise Guide

Some tables can not be viewed in SAS EG

Riana — Fri, 17 Mar 2017 13:12:38 GMT

Hi,

One of my friends works with both SAS EG and Qlik. When he connects to a database in Qlik, he can see tables but with connection in SAS EG to the same database he can not view some of tables. What can be the problem?

Re: Some tables can not be viewed in SAS EG

ballardw — Fri, 17 Mar 2017 14:55:40 GMT

Some might relate to how he connects. If he connects to QLIK through ODBC he would be limited by the capabilites of the ODBC link.

Also there could be issues related to actual table names and EG settings related to valued names. SAS restricts dataset names to 32 characters, no spaces, start with letter or _ and only contain letter, numeral or _. If the table names exceed 32 characters or use different rules the possibly SAS can't map the names to a valid SAS equivalent. At which point I suspect you couldn't see them.

Another is perhaps the way SAS connects it does not have read/view permissions.

Also some tables might more "metadata" related in QLIK and hence should not be used by other programs.

Re: Some tables can not be viewed in SAS EG

Riana — Tue, 21 Mar 2017 07:35:06 GMT

Thank you ballardw for your reply. Can you please explain a little more about the connection issue, the ODBC?