Hi,
I've been trying to use the ODS without any luck in trying to get something printed in scientific notation. I'm using the PROC MIXED to do some regressions and I would like the p-value (ProbF) from the Tests3 table printed as scientific notation instead of <.0001.
I just can't seem to figure out how to use the PROC TEMPLATE and ODS commands in the proper order to generate the output I need. I'm just going to post a small snippet of code I have and hope that someone could point me in the right direction.
Thanks,
Tony
--------------
OPTIONS nocenter nodate;
PROC template;
edit Stat.Mixed.Tests3;
edit ProbF; format=E12.; end;
end;
run;
DATA ILMN_10002;
INPUT @1 rs11152550 $2. @4 rs2228431 $2. @7 rs3747393 $2. @10 rs3747394 $2. @13 rs5939319 $2. @16 rs5982868 $2. @19 rs5982926 $2. @22 score 15.13 @38 sample $3. @42 sex $1. @44 year $4. @49 treatment $4. ;
DATALINES;
GG AA TT AA GG TT GG 9.180736541748 506 1 1981 dex
AA AA CC GG GG TT GG 9.238666534424 507 1 1949 dex
GG AA TT AA GG CC GG 8.720795313517 508 1 1946 dex
GG AA TT AA GG TT GG 10.428975741069 509 2 1938 dex
etc ....
;
ODS listing close;
PROC MIXED DATA=ILMN_10002;
CLASS sample rs11152550 treatment;
MODEL score=rs11152550 treatment ;
REPEATED treatment / SUBJECT=sample TYPE=CS;
lsmeans rs11152550 ;
ods output Tests3 = tata;
run;
ODS listing;
proc print data=tata;
run;
... View more