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?
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.
Thank you ballardw for your reply. Can you please explain a little more about the connection issue, the ODBC?
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: