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
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):
>^ Total number of patients
>^ Total number of patients paid in full
>^ Rate Paid in full/Total
>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?