@rubence Use a ONE LEVEL NAME. This is SAS data step and not SQL syntax.
data KFS; set IFRS17_H.key_figures; where key_figures.pyear='2024'; run;
...or if you're more comfortable with SQL then use SQL.
proc sql;
create table work.KFS as
select *
from IFRS17_H.key_figures
where key_figures.pyear='2024'
;
quit;
The 2nd error message you get show that the SAS data step code gets converted into the DB SQL flavour that then gets sent to the DB for processing (so the where clause could subset the data on the DB side before transferring the data to SAS). ...but because in your code the data step syntax is wrong things ain't working.
If you add below options to your code then you'll get in the SAS log the info which SQL has been sent to the DB for in-database processing.
options sastrace=(,,,d) sastraceloc=saslog nostsuffix;
... View more
