topic Accessing WRDS from SAS OnDemand in New SAS User

Accessing WRDS from SAS OnDemand

kf8642610 — Fri, 26 Apr 2019 11:43:42 GMT

Hi,

I cannot remotely sign onto WRDS from SAS Studio OnDemand. I am using my personal PC (Mac) from outside the campus, and it seems that it is due to the proxy related connection problem. Following are the codes I used:

%let wrds=wrds-cloud.wharton.upenn.edu 4016;
options comamid=TCP remote=WRDS;
signon username=_prompt_;

and

%let wrds=wrds-cloud.wharton.upenn.edu 4016;
options comamid=TCP remote=WRDS;
signon username=xxxx password="xxxxxx";

I was able to log into WRDS when I used the second code on campus using SAS software installed in the university PC. However, none of these are working at the moment in SAS OnDemand.

I even installed/connected to the University VPN, yet it is not working.

I used Terminal to access WRDS cloud since I have Mac, but it is too hard for me to extract data using the Terminal.

I was wondering whether I can remote log onto WRDS using SAS OnDemand off-campus.

Thanks in advance.

Re: Accessing WRDS from SAS OnDemand

Cynthia_sas — Fri, 26 Apr 2019 13:47:07 GMT

Hi:
I do not believe you have that functionality from inside the SAS OnDemand Server. You might want to work with the Wharton support for WRDS to verify. I think you sign on from this site to get to their contact information: https://wrds-www.wharton.upenn.edu/pages/about/?_ga=2.178948132.1283544892.1556286343-1361592916.1555851164#wharton-research-data-services .

Cynthia

Re: Accessing WRDS from SAS OnDemand

kf8642610 — Fri, 26 Apr 2019 16:09:46 GMT

Hi Cynthia,

Thanks for your response. I just received a support from WRDS and now I can use SAS Studio in WRDS!

Best regards,

Vicky

Re: Accessing WRDS from SAS OnDemand

AndreaFSU — Thu, 03 Oct 2019 14:03:03 GMT

Hi Vicky,

Can you let us know what the solution was? Was it a specific command? I am facing a similar problem trying to remote sign-on onto WRDS using SAS studio from my Mac. Thanks!

Andrea

Re: Accessing WRDS from SAS OnDemand

kf8642610 — Fri, 04 Oct 2019 10:15:12 GMT

Hi Andrea,

Instead of accessing WRDS from SAS OnDemand, I logged into my WRDS account and then selected 'Get Data' tab - 'SAS Studio' under PROGRAMS menu - 'Open SAS Studio'. If you click SAS Studio, it will lead you to the log-in page. You just have to type in the same ID and Password you use for WRDS.

If you do this, you do not need to remotely log-in and can just start writing codes or extracting the data directly even by clicking folders such as CRSP and FF (Fama-French) which are in 'My Libraries'. I hope this helps.

Best,

Vicky