Could anyone help me to solve this programming problem?

[anqi9103]

Hi everyone, I am learning to using SAS this week.   Here is the problem I was stuck for a long time.

There is no log and result after I run the code in sas online studio. I have entered the username and password.

%let wrds=wrds.wharton.upenn.edu 4016;
options comamid=TCP remote=WRDS;
signon username=*** password="***";

rsubmit;

libname comp '/wrds/comp/sasdata/nam';
libname compc '/wrds/comp/sasdata/nam/company';
libname crsp '/wrds/crsp/sasdata/a_stock';
endrsubmit;

rsubmit;
proc sql; create table sas_try as select distinct gvkey, datadate, cogs, csho, ni, ppet, prcc_f
from comp.funda
where year(datadate)>=1986
order by gvkey, datadate;
quit;
proc print data=sas_try (obs=100);
run;
endrsubmit;

Hope someone can help me to solve it. Thank you so much!

[andreas_lds]

Where the question?

[anqi9103]

There is no log and result after I run the code in sas online studio. 

I would like to extract some variables from comp.funda dataset and create a new table. But nothing was generated after running the syntax. So what's wrong with my syntax?

Thank you!

[Reeza]

WRDS has some tutorials. Have you tried one of their exact queries to ensure you're set up correctly? It's almost impossible to debug this without any log.

[Amir]

Hi,

Make sure the username and password are both correct and in the same case (upper / lower case) as what you should be using.

Should the the use of WRDS in the remote= option have an ampersand ('&') in front to refer back to the macro variable you set up earlier?

E.g:

options comamid=TCP remote="&WRDS";

as in the top of page 3 in the following paper:

https://support.sas.com/resources/papers/proceedings/proceedings/sugi30/023-30.pdf

Regards,

Amir.