Product:
SAS
Microsoft SQL server 2016
Issue:
Some tables are not visible in SAS client program, even do the same user can see the tables in Microsoft SQL Server Management Studio (SSMS) or Tableau.
As the same user can see the tables inside Microsoft SQL Studio, it is not a permission issue.
Solution:
Change the tables and views in SQL to have shorter names. SAS can not show SQL tables or views that have a name longer than 32 characters.
More Information:
http://support.sas.com/documentation/installcenter/en/ikforecastwofrsr/75572/HTML/default/index.html