Date:         Thu, 21 Dec 2006 13:45:56 -0800
Reply-To:     haleyjo <haleyjo@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         haleyjo <haleyjo@GMAIL.COM>
Organization: http://groups.google.com
Subject:      Re: Crosstab....Which proc??
Comments: To: sas-l@uga.edu
In-Reply-To:  <200612210317.kBKMl6Gu002377@mailgw.cc.uga.edu>
Content-Type: text/plain; charset="us-ascii"

Sorry for the confusion.  Here is a clarification:

I want to turn this data:
Initial         Final           Number on Book  Number Paid In full
a           a                   2753                    25
a           b                   2847                    78
b           b                   2876                    45
b           a                   2729                    233


Into this form of output:

                Final Status
Initial Status          a       b       total
a       Number on Book:          2753   2847    5600
        Number Paid In full:    25      78      103
        Rate (paid/booked):     0.91%   2.74%   1.84%
b       Number on Book:          2729   2876    5605
        Number Paid In full:    233     45      278
        Rate (paid/booked):     8.54%   1.56%   4.96%
total                           5482    5723    11205
                                258     123     381
                                4.71%   2.15%   3.40%