Upon rsubmit to create a table, if the remote server connection gets lost midway and the table is not viewable because the process is still locked, does this mean the job is still running in the backend as a "runaway" and eventually will complete?  ... View more

I have a very large transactions table that contains over 5 billion rows, with about 20 columns in the server.  Because it is so large, I am unable to perform any analysis on this, as the connection the remote server always times out and get the following error: ERROR: Conversation termination; status=1. I've tried to create another table to store just data within one year, or even do an inner join to another table to store a subset of customers' transaction details, but neither have worked - I continue getting the time out error...   Has anyone worked with this kind of dataset? Any tips?    ... View more

I run a simple query like the following: rsubmit; proc sql; create table x.txn_filtered as select * from y.txn_all where ID = 123 ; quit; endrsubmit;   But all I keep seeing is the below log; and I am unable to run anything else, as when I run "quit", I get an error message "A PROC is currently executing..."  30 rsubmit; NOTE: Remote submit to EDW603 commencing.   Given this: 1. Why is the code not being processed? Is it a server performance issue? 2. How would I kill/abort/stop/quit this remote submit process? 3. How can I see all of the rsubmit processes that I am running?    Thank you!      ... View more

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? ... View more