Date: Tue, 1 Mar 2005 03:58:50 +0000
Reply-To: toby dunn <tobydunn@HOTMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: toby dunn <tobydunn@HOTMAIL.COM>
Subject: Re: Proc Tabulate
In-Reply-To: <200503010241.j212fDiT023376@listserv.cc.uga.edu>
Content-Type: text/plain; format=flowed
howard et al....
Thanks for the where filter option I hadn't thought of that (don't know why
though)....
I was looking for away to such that I didn't have teh all or nothing
situation and/or away that was easy to impliment. The case where there MLF
wouldn't include the extreme lower bounds is strictly a extreme case and not
recommended, but as I grow tired of people comming back after I develop a
program that meets there specs and want me to radically change teh code to
encompass reading the mind of requestor I figured I would try to make this
program bullet proof as I can....
Thanks for nudging me along in the right direction....
Toby Dunn
From: "Howard Schreier <hs AT dc-sug DOT org>" <nospam@HOWLES.COM>
Reply-To: "Howard Schreier <hs AT dc-sug DOT org>" <nospam@HOWLES.COM>
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: Proc Tabulate
Date: Mon, 28 Feb 2005 21:41:13 -0500
Do you want to completely exclude the lower values, or roll them up in one
line?
Do you want all of your labels to appear (the PRELOADFMT effect)?
One alternative would be to use a WHERE filter to exclude unwanted data.
That may be more efficient, but it is an all-or-nothing choice?
On Mon, 28 Feb 2005 21:09:23 +0000, toby dunn <tobydunn@HOTMAIL.COM> wrote:
>I have a proc tabulate that I feed a multilabel format, such as:
>
>proc format ;
>value fmt_row (multilabel)
> 1000 - high = '1000'
> 2000 - high = '2000'
> 5000 - high = '5000'
> 7000 - high = '7000'
> 10000 - high = '10000'
> 12000 - high = '12000'
> ;
>run ;
>
>the output contains the right formats as shown above but then also shows
the
>the values for values lower than 1000. Do I need to use the exclusive
>option here or is there a better way?
>
>
>
>
>Toby Dunn
