/*text of sas program to be ran on WRDS cloud server. 
1) Upload program onto your personal cloud folder /home/yourschooldir/yourusername/
2) IN SSH command window, type "qsas program.sas"3) Check log (.log), output (.lst), and output files in your folder
3) Check status of job using "qstat -u username". 
4) "qdel #jobid" to delete job
*/


/*set library name*/
libname myunix "/home/osu/rogerloh/";

/*Get data from CRSP monthly*/
Data myunix.crsp1; 
	set crsp.msf; 
	keep permno date ret prc;
	where date >'31dec2000'd;
run;

/*Count average returns per month*/
Proc sort data=myunix.crsp1; by date permno; run;
Proc means data=myunix.crsp1 noprint; 
	var ret; 
	by date;
	output out=myunix.crsp2(drop=_freq_ _type_) mean=avgret n=numfirms;
run;

/*print to output file*/
proc print data=myunix.crsp2; run;