| Date: | Thu, 9 Oct 2003 08:33:08 -0700 |
|---|
| Reply-To: | Basem <batawfic@YAHOO.COM> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | Basem <batawfic@YAHOO.COM> |
|---|
| Organization: | http://groups.google.com |
|---|
| Subject: | Re: Proc Tabulate - Row Percentage -still need help |
|---|
| Content-Type: | text/plain; charset=ISO-8859-1 |
|---|
As I did not get any help, I feel that I did not describe the problem
clearly
what I want is a report has the following shape
With Intent No Intent Total
Segment/Timing Count Pct Count Pct Count Pct
Inferred 8 1.251% 630 98.591 % 639 100.000 %
Known 82 87.234% 12 12.765 % 94 100.000 %
I 'm using the following code:
> proc tabulate data=output.mot;
> class segment timing;
> var int no_int
> table segment=''*timing='' ,
> All='With Intent'*(
> int='Percentage'*(ROWPCTSUM=''*f=pctfmt9.)
> int='Count'*(SUM='')
> )
> All='No Intent'*(
> no_int='Percentage'*(ROWPCTSUM=''*f=pctfmt9.)
> no_int='Count'*(SUM='')
> )
> / BOX = [LABEL="Segment / Timing"]
> MISSTEXT='0'
> ;
> run;
It gives me perfect count, but wrong percentage as follow: as it is
clear, correct count but always 100% percenatge
With Intent No Intent Total
Segment/Timing Count Pct Count Pct Count Pct
Inferred 8 100% 630 100% 639 100.000 %
Known 82 100% 12 100% 94 100.000 %
Can anyone help me please
| 
