Conversation termination; status=1.

[margalits1]

Hello, could you please help me?

I get the following error after an sql command in SAS. I use WRDS data:

ERROR: Conversation termination; status=1.
ERROR: A link must be established by executing the SIGNON command before you can communicate with
WRDS.
ERROR: Remote submit to WRDS canceled.

I have already tried the following solutions (each apart):

1. Adding- 

rsubmit;

-set CONNECTKEEPALIVE 15;

2. Setting the timeout in sasv9.cfg to max.

This is the command I am trying to run, Perhaps you might have any ideas how to alter it?

proc sql;

       create table firms_list as

       select * from comp2 c

       where exists(

     select * from firms_list a

     where c.year between a.year and a.year+2 and c.gvkey = a.gvkey);

         quit;

   run;

Will appreciate any ideas how to solve this problem. Thank you in advance.

[rudfaden]

Are you signed on to a remote server?

[margalits1]

Yes- the WRDS server

[Patrick]

Have you already seen this problem note?

Problem Note 64599: "ERROR: Conversation termination; status=1" occurs when multiple remote SAS® ses...

[margalits1]

Hi, I get a notice that this hotfix is already installed on Sas Deployment Manager .

I am not sure that it is relevant in the first place, since I am not trying to run *multiple* processes, but a single command. 

[Patrick]

---

@margalits1 wrote:

Hi, I get a notice that this hotfix is already installed on Sas Deployment Manager .

I am not sure that it is relevant in the first place, since I am not trying to run *multiple* processes, but a single command. 

---

I guess you best contact SAS Tech Support directly with this issue.