Error in the access to WRDS

cykim910 — Sun, 23 Jul 2023 07:08:10 GMT

Hello, I'm a novice SAS user.

Thank you for reading this topic.

Whenever I run the following commands

***----------------------------------------------------------------***;
/*Run Remotely on WRDS*/
%let wrds = wrds.wharton.upenn.edu 4016;
options comamid=TCP remote=WRDS;
signon username=_prompt_;
Libname rwork slibref=work server=wrds;

I got the following error message. Could I ask for your help?? 😭

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

7 OPTIONS VALIDVARNAME=ANY;

____________

WARNING 36-12: SAS option VALIDVARNAME is restricted by your Site Administrator

and cannot be updated.

8 OPTIONS VALIDMEMNAME=EXTEND;

____________

WARNING 36-12: SAS option VALIDMEMNAME is restricted by your Site Administrator

and cannot be updated.

73 ***----------------------------------------------------------------**

73 ! *;

74 /*Run Remotely on WRDS*/

75 %let wrds = wrds.wharton.upenn.edu 4016;

76 options comamid=TCP remote=WRDS;

77 signon username=_prompt_;

ERROR: The _PROMPT_ value for USERID or PASSWORD option is only valid if a

TERMINAL is attached to this SAS session.

ERROR: Remote signon canceled.

78 Libname rwork slibref=work server=wrds;

ERROR: Attempt to connect to server WRDS failed.

ERROR: A communication subsystem partner link setup request failure has

occurred.

ERROR: Cannot find TCP service 'wrds'.

ERROR: Error in the LIBNAME statement.

80 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

Re: Error in the access to WRDS

Kurt_Bremser — Sun, 23 Jul 2023 07:52:15 GMT

When using the workspace server (which runs in a kind of "semi-batch" mode), either with SAS Studio or Enterprise Guide, you cannot use features of the Display Manager interface, which includes the ability to prompt for input. Supply the credentials in the code.

Re: Error in the access to WRDS

cykim910 — Sun, 23 Jul 2023 08:09:55 GMT

Thank you for your prompt answer.

So, should I type like..?

signon user=cykim910 password=***********;

Thank you again 🙂

Re: Error in the access to WRDS

SASKiwi — Sun, 23 Jul 2023 20:29:35 GMT

signon username = MyUser password = 'MyPassword';

topic Re: Error in the access to WRDS in SAS Programming

Error in the access to WRDS

Re: Error in the access to WRDS

Re: Error in the access to WRDS

Re: Error in the access to WRDS