Date:         Wed, 20 Dec 2006 22:17:02 -0500
Reply-To:     "Howard Schreier <hs AT dc-sug DOT org>" <nospam@HOWLES.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Howard Schreier <hs AT dc-sug DOT org>" <nospam@HOWLES.COM>
Subject:      Re: Crosstab....Which proc??

On Wed, 20 Dec 2006 13:39:14 -0800, haleyjo <haleyjo@GMAIL.COM> wrote:

>I am trying to create a cross tab, and having trouble getting it to
>contain all of the info that I want.
>
>My data looks like this (I have 2 status variables representing the
>status codes of our patients at two different points in time a year
>apart (Medicare, Medical, Commercial, HMO) and then 4 count variables
>-- 2 counts for each status (count of patients with that status, count
>of patients with that status paid in full at that time):
>
>StatusONE Count1 Count2 StatusTWO(6 months later) Count1B Count2B
>Medicare 300 240 HMO 1000 400
>Commercial 4000 2000 Medicare 200 50
>etc.....

I'm perplexed. It seems to me that there should be one count, not two, of
patients who were Medicare on Date A and HMO on Date B. There would be
separate (date-specific) counts for payment status however.

I suggest that you post a complete, though possibly simplified, data set and
a mockup of the output which should result, with headings and filled-in cells.

>
>I want output from the file in a crosstab for the two status' so that
>it looks like this below (StatusONE by StatusTWO) showing the total
>number of patients, the total number of patients paid in full and the
>rate (paid in full/total number):
>
>
>
>^               <<<<<======StatusTWO====>>>>
>^
>^                              Total number of patients
>^                              Total number of patients paid in full
>^                              Rate  Paid in full/Total
>StatusONE
>^
>^
>^
>
>I can get pieces of this with proc report, & proc means....but I am
>missing the mark to get exactly what I want above.  Any thoughts?