Date:         Tue, 27 Sep 2011 12:09:49 -0400
Reply-To:     Santosh Nazare <santosh.nazare@MAINE.GOV>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Santosh Nazare <santosh.nazare@MAINE.GOV>
Subject:      Re: sas help
Comments: To: SUBSCRIBE SAS-L Anonymous <mujamailkaro2010@GMAIL.COM>

Hi,

You can use proc report to this:

E.g.
data one;
input  region $ sex $ years_end_0or5 age23to62;
cards;
a F 5939 29646
a M 236024 668840
b F 5320 28941
b M 5853 29356
c F 5702 29516
c M 6451 29538
; run;



proc report data=one split='*';
column region sex years_end_0or5 age23to62;
define region/ group width=6 'Region*--';
define sex/ group width=6 'Gender*--';
define years_end_0or5 / analysis 'years_end_0or5';
define age23to62/ analysis 'age23to62';
break after region /ol skip summarize supress;
title '';
run;

----------------

Replace 'years_end_0or5' and 'age23to62' with appropriate titles

-Santosh