Creating a library then creating a table in Base SAS 9.4

[tiramisu]

My goal is to create a table in library abc using data within a remote server (i.e. my organization's data warehouse):

libname abc 'C:/Users/xxx/Desktop/SAS';

The above runs successfully, and then I am able to see and access library abc on the explorer window on the left side.

Then, I submit the following:

proc sql;
connect to db2(database = aaa user=&user. password=&pw.);

create table abc.srv_table_1 as
select *
from srv.table_1
;
quit;

The creation fails and outputs the following in the log:

ERROR: Library abc does not exist

What am I missing here?

[Kurt_Bremser]

Please run the LIBNAME and the SQL in one submit, and then post the complete log from that, using the </> button.