Date: Wed, 30 Nov 2005 23:05:47 -0600
Reply-To: Herbert Morley A <Morley.Herbert@HCAHEALTHCARE.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Herbert Morley A <Morley.Herbert@HCAHEALTHCARE.COM>
Subject: Add row to table
Content-Type: text/plain; charset="iso-8859-1"
I have used Proc Freq to create an output table. One of the cells in the table has a count of 0 and is missing in the output data set.
TABLES tvessel * proc / OUT = m1;
The table m1 looks like this: (simulated)
tvessel proc count %
No CABG 1098 92.0
No CATH 855 70.0
Yes CATH 28 8.0
I need it to have a fourth row eg:
Yes CABG 0 0
I am adding together several tables and then using the results.
Adding a new row is not the issue. I am drawing a blank on how to detect which row is missing so I can add the extra row. I want to define its count as 0.
The missing row is not always the same. It will be the yes field but may be CABG or CATH.
Sorry if this is 'clear as mud'.
Thanks for any suggestions