I am trying to access Oracle dtabases. Once I signon to the remote server which has SAS CONNECT, I do an RSUBMIT and connect to Oracle and I can print the data but when I try to view it using the SAS browser or FSV on my desktop installed SAS, it is not there. It looks almost as the datasets are being created up on the server and I can't view them (but I can print them using PROC PRINT). Do you know what I might be doing wrong?

signon server1;

rsubmit;

proc sql; connect to oracle (user=tf123 pw=test path='PATH1');

SQL Code | | v

quit;

endrsubmit;