Creating a library then creating a table in Base SAS 9.4

tiramisu — Mon, 14 Dec 2020 17:35:40 GMT

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?

Re: Creating a library then creating a table in Base SAS 9.4

Kurt_Bremser — Mon, 14 Dec 2020 18:02:52 GMT

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