Date:         Thu, 27 Mar 2003 14:41:09 -0800
Reply-To:     Doug <queanbeyan@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Doug <queanbeyan@HOTMAIL.COM>
Organization: http://groups.google.com/
Subject:      Help with extra column in tabulate
Content-Type: text/plain; charset=ISO-8859-1

Hi

I have the following code that I run to create a percentage column and
a total of the percents (100%) and a total number of obs in the
column.  However when I include the colpctn I get an extra blank
column.  Any ideas on removing this?

proc tabulate data=service.strip;
        class servtype sector;
        table ((sector=' ' all='Total')*(colpctn=' '))*f=6.1 (all='Total
number of agencies')*f=8.,
                (servtype=' ')/ rts=38 box='Type of ownership';
        keylabel        n=' ';
        where status in ('ACT','PLN')
                and put(servtype,$stype.) ne 'OTH';
run;

Any assistance appreciated.

Doug