Desktop productivity for business analysts and programmers

Some tables can not be viewed in SAS EG

Reply
Frequent Contributor
Posts: 106

Some tables can not be viewed in SAS EG

 

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?

 

 

 

 

 

 

Super User
Posts: 11,118

Re: Some tables can not be viewed in SAS EG

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.

 

Frequent Contributor
Posts: 106

Re: Some tables can not be viewed in SAS EG

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

Ask a Question
Discussion stats
  • 2 replies
  • 158 views
  • 0 likes
  • 2 in conversation