SAS Support Communities

Hi,   I have the following ODBC connection:     LIBNAME IFRS17_H ODBC DATAsrc=IFRS17_HIVE SCHEMA=ifrs17catalog USER="rubence" PASSWORD="XXXXXXXXXXX";   When I try to use a WHERE clause,  data KFS; set IFRS17_H.key_figures; where key_figures.pyear='2024'; run; SAS shows the following message:     but if I do not use a WHERE clause, I have no problems and the var names in the new table follows the structure: TABLE_NAME.VAR_NAME.   My questions are: a) How can I avoid to download the full table? b) Is It possible to use only the VAR_NAME and not TABLE_NAME.VAR_NAME?   Many thanks for your great help.   ... View more