BookmarkSubscribeRSS Feed
cykim910
Calcite | Level 5

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

 

cykim910_0-1690095973650.png

 

3 REPLIES 3
Kurt_Bremser
Super User

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
Calcite | Level 5

Thank you for your prompt answer.

So, should I type like..?

 

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

 

Thank you again 🙂 

 

SASKiwi
PROC Star

signon username = MyUser password = 'MyPassword'; 

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 990 views
  • 1 like
  • 3 in conversation