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