SAS PC CONNECT - Cannot find a dataset created...

[smilingmelbourne]

Hello everyone,

After successfully connecting to a remote server, I ran the following codes without errors (according to the SAS log). However, I cannot find the dataset (msex1) created. In local SAS, this "msex1" dataset is supposed to be in temporary WORK library, but I am not sure whether it should be so having the remote SAS. I've been using SAS for a while now, but the past several days are the first time I have been trying to learn to use SAS CONNECT, so I have found this really confusing. Can anyone please help?

rsubmit;
libname crsp '/wrds/crsp/sasdata/sm';
proc sort data=crsp.mseall(keep=date permno exchcd shrcd siccd) out=mseall nodupkey;
where exchcd ne . or shrcd in (10,11);
by permno date exchcd;
run;

proc sql;
create table msex1 as
select *
from crsp.msf(keep=date permno cusip prc shrout ret) as a
left join
mseall as b
on a.permno=b.permno and a.date= b.date;
run;
quit;
endrsubmit;

By the way, how can I wrap the codes so you can see it more easily?

[Doc_Duke]

As msex1 is within the rsubmit/endrsubmit block, the work library that is used is the one on the remote server.