Sign-on in EG 4.3: doesn't work and logs stop working

[Arsenio_Staer]

Dear all,

I'm connecting in EG to a remote SAS server and the same code seems to work fine in base SAS 9.3 but in EG 4.3 it just stalls the local server with the message "Running:....", ( and log facilities stop working (e.g. running sort task on a dataset doesn't produce a resulting dataset and/or anything in the log window, it just sort of blinks). If i disconnect the local SAS server and reconnect again, I can see logs again but still can't use sign-on.

Code:

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

options comamid=TCP;

signon wrds username=_prompt_;

RSUBMIT;

In base SAS running this code immediately pops up the login prompt and in EG it exhibits the behavior mentioned above. No idea what's going on, EG shouldn't interfere at all with this sign on process, right? Tried to google this, found nothing.

Thanks,

Arsenio

[LinusH]

You are a little bit scant of your environment description.

One guess is that there is a common confusion about connection methods to a SAS server from different clients.

On SAS DMS client ("Base"), the common method is to use SAS/CONNECT with signon statement (as in cour example).

When connection to a SAS server from i.e. Enterprise Guide, you another connection method, using something call IOM. The client login to the Metadata Server (specified in the metadata server), when authenticated, your will use a Workspace Server as the server side SAS session, not a SAS7CONNECT one. All this will happen without  signle line of traditional SAS code.

Your code is unlikley to work (probaably there is need for it any more), unless you chose a local SAS metadata server, and that local SAS has SAS/CONNECT installed.

/Linus

[twocanbazza]

I would suggest that it is sitting there wainting for you to enter you user ID and password as you have used _prompt_ - not a good option to use if you are submitting to a workspace server (which is not running in interactive mode)

Barry

[TimB_SAS · Accepted solution]

To echo what Barry has said - you will not be able to use _PROMPT_ to supply credentials to the remote server.  You will need to supply the USER= and PASS= options on the SIGNON statement.

[Arsenio_Staer]

Guys, sorry for late answer!

I will try to do this tonight/tomorrow. Thanks for the replies! It does seem like a window is being created, but I couldnt find it anywhere on the desktop.

@LinusH,

thanks for that info! I have no idea though how to adapt it to a local metadata server, and i guess folks in our department or at WRDS have no idea either. Looked in help files, couldn't find the info. The only way documented is through the usual SAS/CONNECT (a guess?). I'm not sure how i can get the environment description or what do you mean by that?

@TimB,

I just now checked the pass submitting option and it works! Was a bit confused by all the password encoding in the help file!

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

16         options comamid=TCP;

17         signon wrds username=XXXXXXXX password=XXXXXXXXXX;

NOTE: Remote signon to WRDS commencing (SAS Release 9.03.01M0P060711).

NOTE: Copyright (c) 2002-2008 by SAS Institute Inc., Cary, NC, USA.

NOTE: SAS (r) Proprietary Software 9.2 (TS2M3)

      Licensed to UNIVERSITY OF PENNSYLVANIA - T&R, Site 70001358.

NOTE: This session is executing on the SunOS 5.10 (SUN 64) platform.

Thanks guys!

Arsenio