Error in the access to WRDS

[cykim910]

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;

____________

36

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

and cannot be updated.

8 OPTIONS VALIDMEMNAME=EXTEND;

____________

36

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

and cannot be updated.

72

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.

79

80 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

92

[Kurt_Bremser]

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.

[cykim910]

Thank you for your prompt answer.

So, should I type like..?

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

Thank you again 🙂 

[SASKiwi]

signon username = MyUser password = 'MyPassword';