11-09-2015 08:11 PM
I am trying to access data from WRDS using SAS/CONNECT.
The code I type into my program is:
%let wrds=wrds.wharton.upenn.edu 4016; options comamid=TCP remote=WRDS; signon username=_prompt_;
The errors returned are:
ERROR: The _PROMPT_ value for USERID or PASSWORDoption is only valid if a TERMINAL is attached to this SAS session.
ERROR: Remote signon canceled.
This error seems to be caused by the fact that I am in Enterprise Guide. I cannot access the plugin menu for some reason, and cannot change the settings on my Server Manager as a result. What steps do I need to take in order for me to access the data?
11-09-2015 08:23 PM
When you're using SAS/CONNECT within Enterprise Guide you can't use the same prompt window that you could from "old school SAS". Paragraph III of this paper http://analytics.ncsu.edu/sesug/2013/CC-22.pdf shows you how to prompt for a password (or any other parameter you wish to use).
11-09-2015 08:25 PM
I'm sorry, I made a mistake in my original post. I don't believe I have SAS Enterprise Guide - I have SAS 3.2 for Single User. Is there an answer for my question assuming this is the software I have?
11-09-2015 08:37 PM
I think you must mean SAS Studio 3.2 as PC SAS 3.2 would be ancient. If that is the case then I don't believe it's possible to use SAS/CONNECT from SAS Studio. I've never used WRDS but if there is some sort of web API you may be able to retrieve the data with Proc HTTP otherwise I think you might have to download it outside of SAS.
11-10-2015 01:55 PM
Check your licence to see if SAS/CONNECT is included: proc setinit noalias; run;
I'd give the SIGNON a try anyway with the USERNAME and PASSWORD options.