Date:         Tue, 17 Dec 2002 10:53:21 +0800
Reply-To:     =?gb2312?q?Johnson=20Chang?= <jchangmail@YAHOO.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         =?gb2312?q?Johnson=20Chang?= <jchangmail@YAHOO.COM>
Subject:      Re: PROC FREQ printing all frequencies (including 0-count
              categories)
Comments: To: friendly@yorku.ca
In-Reply-To:  <3DF768B7.4219A04A@yorku.ca>
Content-Type: text/plain; charset=gb2312

and MISSING option.

 --- Michael Friendly <friendly@YORKU.CA> 的正文：> Try the SPARSE option on the TABLES
statement
>
> "Braten, Michael Exchange" wrote:
> >
> > Your solution MAY lie in using a PRE-LOAD format  which is reactively new to
> > SAS.
> > > -----Original Message-----
> > > From: Susie Li [SMTP:Susie.Li@US.SANOFI.COM]
> > > Sent: Tuesday, November 26, 2002 2:35 PM
> > > To:   SAS-L@LISTSERV.UGA.EDU
> > > Subject:      PROC FREQ printing all frequencies (including 0-count
> > > categories)
> > >
> > > How do I make sure that PROC FREQ will give me all contiguous categories,
> > > rather than only categories where there are frequency counts?  See
> > > example:
> > >
> > > proc format;
> > >      VALUE FREQP
> > >           0- 4= '0'
> > >            5- 9= '5'
> > >            10-14='10'
> > >           15-19='15'
> > >            20-high='20+';
> > >
> > >
> > > * NUMBER OF Doctors BY frequency CATEGORY;
> > > PROC FREQ DATA=demo;
> > >      TABLES docsttl/NOPRINT OUT=DCUST;
> > >      FORMAT docsttl FREQP.;
> > >
> > > PROC SORT DATA=DCUST;
> > >      BY docsttl;
> > > run;
> > >
> > >
> > > Susie Li
> > > Sanofi-Synthelabo, Inc.
> > > 90 Park Ave
> > > New York, NY 10016
> > > (212)551-4385
> > > susie.li@us.sanofi.com
> > >
> > >
> > > Important:  The Information in this e-mail belongs to Sanofi-Synthelabo
> > > Inc., is intended for the use of the individual or entity to which it is
> > > addressed, and may contain information that is privileged, confidential,
> > > or exempt from disclosure under applicable law.  If you are not the
> > > intended recipient, you are hereby notified that any disclosure, copying,
> > > distribution, or use of, or reliance on, the contents of this e-mail is
> > > prohibited.  If you have received this e-mail in error, please notify us
> > > immediately by replying back to the sending e-mail address, and delete
> > > this e-mail message from your computer.
> >
> >  ****************************************************************
> > Bear Stearns is not responsible for any recommendation, solicitation,
> > offer or agreement or any information about any transaction, customer
> > account or account activity contained in this communication.
> > ***********************************************************************
>
> --
> Michael Friendly              friendly@yorku.ca
> York University               http://www.math.yorku.ca/SCS/friendly.html
> Psychology Department
> 4700 Keele Street             Tel:  (416) 736-5115 x66249
> Toronto, Ontario, M3J 1P3     Fax:  (416) 736-5814

_________________________________________________________
Do You Yahoo!?
"您想享受2－7折星级酒店价格吗？"
http://cn.travel.yahoo.com/