Prev: How to declare an list and loop in it
Next: SAS 9.2 and Ubunut 9.10
From: Jinto83 on 4 Apr 2010 00:39
Hi,

I wonder how to direct the output of proc means somewhere so I can generate summary table that contains results from MULTIPLE proc means runs.

For example, I have three files:
work.sales
work.profit
work.income

Each file has two classes:
brandvariable=Toyota
brandvariable=Ford

How do I use a single sas script to generate a 6by2 Table:

The 6 rows are:
1.mean sales
2.variance sales
3.mean profit
4.variance profit
5.mean income
6.variance income

The 2 Columns are :
1.Toyota
2.Ford


Normally I would just run proc means three times, each on work.sales, work.profit, work.income, but I wonder if there is any way better than just manual cut/paste.
Thank you very much.

--- news://freenews.netfront.net/ - complaints: news(a)netfront.net ---
From: Patrick on 4 Apr 2010 03:55
If possible: First combine the 3 datasets into one and then use Proc
Tabulate (or Proc Report).
From: Andrew Karp Sierra Info Services on 4 Apr 2010 19:31
On Apr 4, 12:55�am, Patrick <patrick.mat...(a)gmx.ch> wrote:
> If possible: First combine the 3 datasets into one and then use Proc
> Tabulate (or Proc Report).

Another option would be to run the three PROC MEANS steps, adding an
OUTPUT statement to each to "capture" the desired statistics/analyses
together then either merge or concatenate them, as exact circumstances/
needs dicatate.

There are multiple examples of how to use the OUTPUT Statement in PROC
MEANS in my free-to-download PDFs available from my web site at
http://www.sierrainformation.com From the home page, click on "free
downloads" and take things from there.

Hope this helps.

Andrew Karp
Sierra Information Services
http://www.sierrainformation.com
 | 
Pages: 1
Prev: How to declare an list and loop in it
Next: SAS 9.2 and Ubunut 9.10