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?
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;
create table msex1 as
from crsp.msf(keep=date permno cusip prc shrout ret) as a
mseall as b
on a.permno=b.permno and a.date= b.date;
By the way, how can I wrap the codes so you can see it more easily?