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.
I think you may be editing the wrong template. It looks like Stat.Mixed.Test3 has this parent statement -- parent = Stat.Mixed.FTests; So, if you go look in Stat.Mixed.Test3, there is no ProbF column for you to edit...I'm guessing that your table template just ignores the edit statement for a column that it can't find in Stat.Mixed.Test3.
If you look inside the parent template, you do find a column for ProbF. So when I used the BP data set from a PROC MIXED example with THIS template definition (change Stat.Mixed.FTests and then change Stat.Mixed.Test3), I get the E notation used for the PROC MIXED results:
ods select tests3;
/*---Model 1, general linear model with clinics assumed to be
a fixed effect---*/
proc mixed data=bp;
class trt visit complier clinic stratum;
model sbp = sbpbl trt
repeated visit / type=vc sub=person;
What you'll find is that if you look in WORK.TEMPL template store, you'll have the parent template and the child template. Now, when you run your PROC MIXED, the change has been made to PROBF in the parent and so the child that's used for PROC MIXED had the E notation.
To return the ODS path to the usual PROC MIXED table templates, you would have:
ods path sashelp.tmplmst(read);