Date:         Wed, 2 Aug 2006 06:12:22 -0700
Reply-To:     BK <byronkirby@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         BK <byronkirby@GMAIL.COM>
Organization: http://groups.google.com
Subject:      Re: proc means format
Comments: To: sas-l@uga.edu
In-Reply-To:  <1154505387.214639.298130@m79g2000cwm.googlegroups.com>
Content-Type: text/plain; charset="iso-8859-1"

if you set two variables (male and female) equal to the income with
their default values being null (.) this will work.

proc means data=test noprint;
by year months;
var male female;
output out=gotit sum=;
run;

proc print data=gotit;
run;



skyline wrote:
> Hello,
>
> Suppose I want to compupte the mean of income for each year, each month
> and each sex. I can get the value by
>
> proc means data=test;
> by year month sex;
> run;
>
> But I would like to have output formatted as
>
> year month male female
> 2006 1        (some number) (some number)
> 2006 2        (some number) (some numebr)
>
> how should I choose the options of proc means?
>
> Thank you,