libname in 'C:\Documents and Settings\WHALEN\Desktop' access=readonly;
libname ronaldo 'C:\Documents and Settings\WHALEN\Desktop\Short Course\Jan12data';
options nofmterr;

proc format; value rf 1='high dose'
                      2='low dose'
		              3='no drug'
		               ;
run;

data neweff; set in.eff;
  if status='Completed';
run;

data neweffonerec; set neweff;
  if week=99;
run;

proc means  n mean std min p25 median p75 max data=neweffonerec;
  var age;
run;

proc freq data=in.eff;
  tables week;
run;
  
data aa; input csite subjid $ pain week; 
datalines;
1       aaa1            9     1
1       aaa1            7     2
1       aaa1            5     3
1       aaa2            8     1
1       aaa2            7     2
1       aaa2            4     3
;
run;

proc means data=aa;
var pain; 
run;

proc sort data=pfeprice out=newpfeprice; by date; 
run;

proc gplot data=pfeprice;
   plot adj_close*date;
run;

data ronaldo.neweff; set neweff; 
run;
data ronaldo.ne; set neweffonerec; 
run;
data ronaldo.pfeprice; set pfeprice;
run;
data ronaldo.newpfeprice; set newpfeprice; 
run;