Date: Sat, 28 Jul 2007 09:19:59 -0400
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: Proc Tabulate
On Sat, 28 Jul 2007 03:56:13 -0700, RAMS <ramsathish@GMAIL.COM> wrote:
>Dear ALL,
>
> I have a data like,
>
>data new;
>input system $ findings $ visit $;
>cards;
>car abnormal base
>car abnormal base
>car normal base
>car normal eot
>car normal eot
>resp abnormal base
>resp abnormal base
>resp abnormal base
>resp abnormal eot
>resp normal eot
>resp normal eot
>;
>run;
>
>and i want a output like,
>
>System Findings Base End
> n % n %
>car abnormal 2 66.67 0 0
> normal 1 33.33 2 100
>
>car abnormal 3 100 1 33.33
> normal 0 0 2 66.67
>
>I am not able to get this by using Proc Tabulate.
>
>Please help me to do it.
>
>Thanks in advance,
>
>Regards,
>
>Ramsathish S
This should take care of everything except cosmetics:
proc tabulate data=new;
class system findings visit;
table system * findings
,
visit * ( n pctn<findings> );
run;
|