Have you never used ODS OUTPUT...

On 4/30/07, Gerhard Hellriegel <gerhard.hellriegel@t-online.de> wrote: > ODS would not really help you for that. With ODS you can get output to a > certain format (RTF, PDF, HTML, ...) instead of sending it to the SAS > output window. If you are successful in producing that output in SAS, it's > no problem to get it in ODS. But the first thing is to get it. > > If I understand that right, PROC SUMMARY might a idea. > > proc summary data=sashelp.class nway; > class sex; > var _numeric_; > output out=x mean=; > run; > > produces averages für the two sex-groups. With that you don't have much > control. E.g. if your grouping variable is numeric, that won't work like > above. > Maybe the macro isn't that bad and you should show us the error messages? > Perhaps with a few changes it will run? > Otherwise you should tell more details what you want to see. > Gerhard > > > > > > On Mon, 30 Apr 2007 10:42:19 -0400, Peter Flom > <peterflomconsulting@MINDSPRING.COM> wrote: > > >Hello again > > > >I have a data set with about 900 variables. One variable will be used as > a 'grouping' variable. > > > >My boss would like (as part of data exploration, not for final work, a > table with the following information. > > > >1. Variable name > >2. Means for each variable for each of two groups > >3. STD for each variable for each of two groups > >4. Coefficient of variation for each variable for each of two groups > >5. F test from an ANOVA or t-test comparing the variables > >6. p value from the F or t-test > > > > > >(for a total of nine columns and a lot of rows) > > > >She wants this sorted by p-value, and only for cases where the p-value is > under .05 > > > > > >My predecessor here, who was prone to complex programs, wrote a long > macro (with no comments) which I do not understand. It worked for him, it > doesn't work for me, I don't know why. > > > >I was thinking that this should be RELATIVELY easy in ODS..... > >to be fair, my predecessor wrote the macro before ODS existed. > > > >Any guidance would be appreciated. > > > >Again, as a frequent critic of automatic selection methods, I know this > isn't a good idea for an ANALYSIS plan, and we aren't using it as such. > > > > > >Thanks! > > > >Peter >