Date:         Mon, 8 Mar 2010 04:28:17 -0800
Reply-To:     Killer <kk.majji@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Killer <kk.majji@GMAIL.COM>
Organization: http://groups.google.com
Subject:      Re: Proc tabulate....N defaulting on output
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

On Mar 7, 11:07 pm, art...@NETSCAPE.NET (Arthur Tabachneck) wrote:
> Suzanne,
>
> I'm sure it will be easier for someone on SAS-L to respond if you
> provide the list with some sample data (in the form of a datastep) and
> the code you are using to run the proc tabulate.
>
> Art
> ------------
> On Mar 7, 12:36 pm, Suzanne_P <p2...@safe-mail.net> wrote:
>
>
>
> > Help!
>
> > "N" and values always appear at the bottom of each column of my proc
> > tabulate output. I am not specifying N in the procedure, but N (number
> > of observations) is always output at the bottom of each table
> > created.
>
> > How do I stop N appearing? I would appreciate any help!
>
> > Thankyou
> > Suzanne.- Hide quoted text -
>
> - Show quoted text -

Suzane,

try this...


ods

listing;

ods

html

body

="body.html";
proc tabulate data =libref.fileref;
   class XXXXX;
   class yyyyy  / order=data;
   var 123;
     tables
XXXXX={label=''STYLE(CLASSLEV)={FOREGROUND=#3366FF BACKGROUND=#FFFFFF}}
*{STYLE={FOREGROUND=#3366FF BACKGROUND=#FFFFFF}}
All={label='Total'STYLE={FOREGROUND=#3366FF BACKGROUND=#FFFFFF}}
*{STYLE={FOREGROUND=#3366FF BACKGROUND=#FFFFFF}},
(YYYYY={label=''STYLE(CLASSLEV)={FOREGROUND=#3366FF
BACKGROUND=#FFFFFF}}*{STYLE={FOREGROUND=#3366FF BACKGROUND=#FFFFFF}}
*123={label=''}*N={label=''}*f=6.)
/BOX= {label='abc'STYLE={FOREGROUND=#3366FF BACKGROUND=#FFFFFF}};
   run;
ods html close;