remote acces via the WRDS cloud: A communication subsystem partner link setup request failure has occurred.
Posted: 22 June 2016 10:41 PM   [ Ignore ]
Newbie
Rank
Total Posts:  5
Joined  2013-06-20

I am trying to run a SAS program that worked fine under the old system. However, in the cloud, WRDS fails.

NOTERemote signon to WRDS commencing (SAS Release 9.04.01M2P072314).
ERRORA communication subsystem partner link setup request failure has occurred.
ERRORNo route to host
ERROR
Remote signon to WRDS canceled.
ERRORA link must be established by executing the SIGNON command before you can communicate with WRDS.
NOTESubsequent lines will be ignored until ENDRSUBMIT.
ERRORRemote submit to WRDS canceled

The code that I runs is as follows, it is really basic, see below.

Any help is welcome!

Martien

%let wrds wrds-cloud.wharton.upenn.edu 4016;
/*%let wrds = wrds.wharton.upenn.edu 4016;*/
options comamid=TCP remote=wrds;
/*signon username=_prompt_;*/
signon username=blucap password="1234567garbled^&";
libname local "/home/vuwnz/blucap/roger/";
rsubmit;

data elist
input permno begdat enddat ;
informat begdat yymmdd8enddat yymmdd8. ;
format begdat yymmdd8enddat yymmdd8. ;
datalines;
1695 19901231 19911231
1695 19910331 19920331
1695 19910630 19920630
1695 19910930 19920930
775 19900331 19910331
775 19900630 19910630
775 19900930 19910930
775 19901231 19911231
775 19910331 19920331
775 19910630 19920630
775 19910930 19920930
;
run;
 
proc sql;
   
create table return1
   
as select a.*, b.retb.date
   from elist 
as acrsp.msf(keepdate permno ret) as b
   where a
.permno b.permno and (b.date a.begdat and b.date <= a.enddat);
   
quit;
   
run;
 
proc sql;
   
create table return2
   
as select a.*, b.vwretd
   from return1 
as acrsp.msi(keepdate vwretd) as b
   where a
.dateb.date ;
   
quit;
   
run;
 
data return3set return2;
logret log(1+ret);
logretw log(1+vwretd);
 
proc sort;
by permno begdat enddat date;
 
proc means;
var 
logret logretw;
by permno begdat enddat;
output out=sumoflogs sum (logret logretw  ) = cumlogret cumlogretw;
 
data mydata;
set sumoflogs;
cumret=exp(cumlogret) - 1;
cumretw=exp(cumlogretw) - 1;
keep permno begdat enddat cumret cumretw ;

proc download data=mydata out=local.returndata;
run;
endrsubmit;

proc print data=local.returndata (obs=30);
run;
proc export data=local.returndata outfile"returns.dta" REPLACE;
run

 

 

 

 

 

Profile
 
 
Posted: 23 June 2016 12:20 PM   [ Ignore ]   [ # 1 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  901
Joined  2011-09-19

MA pm’ed me that it was resolved:

“This message may be caused by one of the following issues:
You have exceeded your quota on WRDS
You have reached the maximum amount of concurrent queries
Your connection timed out due to inactivity
You tried to cancel remote statements using the “break” button in PC-SAS”

 Signature 

To reply/post new questions: Please use the group WRDS/SAS on Google Groups! http://groups.google.com/d/forum/wrdssas

Profile
 
 
Posted: 27 June 2016 04:33 PM   [ Ignore ]   [ # 2 ]
Newbie
Rank
Total Posts:  5
Joined  2013-06-20

Solved.

I run qsas via SSH in a linux / unix terminal; for which no login is required.

You have to add a line that sets the output library:

So, the top of the code is:

libname local "/home/vuwnz/blucap/roger/";
libname out   "/home/vuwnz/blucap/roger/";

data elist
input permno begdat enddat ;
informat begdat yymmdd8enddat yymmdd8. ;
format begdat yymmdd8enddat yymmdd8. ;
datalines;
35722 19890331 19900331
35722 19890630 19900630
35722 19890930 19900930
... 

The end of the code is, where I added some lines to save the data (and get rid of the rsubmit part), is as follows:

data mydata;
set sumoflogs;
cumret=exp(cumlogret) - 1;
cumretw=exp(cumlogretw) - 1;
keep permno begdat enddat cumret cumretw ;

/*this is new:*/
data out.data_save;
    
set WORK.MYDATA;
run;
/*this is old: */
/**proc download data=mydata out=local.returndata;*/
/*run;*/
/*endrsubmit;*/

proc print data=local.returndata (obs=30);
run;
/*proc export data=local.returndata outfile= "returns.dta" REPLACE;*/
/*run;*/ 

 

 

Profile
 
 
Posted: 27 June 2016 04:39 PM   [ Ignore ]   [ # 3 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  901
Joined  2011-09-19

Thanks for following up! smile

Joost

 Signature 

To reply/post new questions: Please use the group WRDS/SAS on Google Groups! http://groups.google.com/d/forum/wrdssas

Profile