Groups | Search | Server Info | Login | Register

Groups > comp.soft-sys.sas > #993

Re: How to output proc means result to a dataset?

Show all headers | View raw

Actually, I want to generate a summary report with multiple proc means
results, like

*****************************************
Type        count      Amount
VISA           200        123.30
MC               50          21.40
Sears            23      1231.50

City               count     Amount
Boston           12           234,23
New York         234          23.4

:
:

Event       count     Amount
X1              34         23423.23
...
Xn              1234       123.90
**********************************************
And the results are generated by more than one PROC Means. I hope to
know how to output the results.

Thanks.

Anne
>
>
> > Hi,
> > I got a simple result from means that contains three columns only, eg.
> > type, count, amount.
> > I use the following code to get the result:
>
> > proc means data= multiple N sum noobs;
> >         var GTAmt ;
> >         class Type;
> >     where GTAmt >0 and GTAmt ^=.;
> >  run;
>
> > Since I have more than one peices of proc means to output, I guess I
> > need to put in a dataset then print it out.
> > But how to do it? Anyone can help?
> > Thanks in advance.
>
> > Anne
>
> I guess I don't understand. Your PROC MEANS, as it exists, will output
> the information computed by PROC MEANS. Why do you need a dataset?
>
> By the way, where GTAmt >0 and GTAmt ^=.; is redundant, as a missing
> value is treated as negative infinity, so it is not greater than zero.
>
> --
> Paige Miller
> paige\dot\miller \at\ kodak\dot\com- Hide quoted text -
>
> - Show quoted text -

Back to comp.soft-sys.sas | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

How to output proc means result to a dataset? A Xu <xxu.geo@yahoo.com> - 2011-06-23 09:01 -0700
  Re: How to output proc means result to a dataset? "Kenneth M. Lin" <kenneth_m_lin@sbcglobal.net> - 2011-06-23 09:39 -0700
  Re: How to output proc means result to a dataset? Paige Miller <paige.miller@kodak.com> - 2011-06-23 10:01 -0700
    Re: How to output proc means result to a dataset? A Xu <xxu.geo@yahoo.com> - 2011-06-23 11:25 -0700
      Re: How to output proc means result to a dataset? Paige Miller <paige.miller@kodak.com> - 2011-06-23 12:28 -0700
        Re: How to output proc means result to a dataset? A Xu <xxu.geo@yahoo.com> - 2011-06-23 12:49 -0700
          Re: How to output proc means result to a dataset? Paige Miller <paige.miller@kodak.com> - 2011-06-24 08:50 -0700
            Re: How to output proc means result to a dataset? A Xu <xxu.geo@yahoo.com> - 2011-06-24 11:14 -0700
              Re: How to output proc means result to a dataset? Paige Miller <paige.miller@kodak.com> - 2011-06-28 06:50 -0700

csiph-web