Date: Mon, 30 Apr 2007 11:05:55 -0400
Reply-To: "data _null_;" <datanull@GMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "data _null_;" <datanull@GMAIL.COM>
Subject: Re: ODS vs. Macro for a complex printout request
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Have you never used ODS OUTPUT...
On 4/30/07, Gerhard Hellriegel <email@example.com> 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=;
> 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
> 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.
> 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.