Date: Thu, 4 Feb 2010 14:15:24 -0500
Reply-To: Jim Groeneveld <jim.1stat@YAHOO.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Jim Groeneveld <jim.1stat@YAHOO.COM>
Subject: Re: Negative numbers in a PROC FORMAT value clause
I think it should work correctly without the parens. So:
VALUE eng_back low--1 = green
-1-0 = yellow
0-1 = red
1-high = black
as it is unambiguous.
More readable would be to insert spaces:
VALUE eng_back low - -1 = green
-1 - 0 = yellow
0 - 1 = red
1 - high = black
Question: how about the range limits themselves?
Might it be better to code something like:
VALUE eng_back low -< -1 = green
-1 -< 0 = yellow
0 -< 1 = red
1 - high = black
Regards - Jim.
Jim Groeneveld, Netherlands
Statistician, SAS consultant
On Thu, 4 Feb 2010 13:53:58 -0500, Horne, Jim - James S
>I have a stupid question that I can't seem to find an answer to. I need to
specify negative numbers in a value clause in PROC FORMAT and don't know how
to do it and don't see how in the literature. What I want to do is
something like the following but I don't know the right syntax.
>VALUE eng_back low-(-1) = green
> (-1)-0 = yellow
> 0-1 = red
> 1-high = black
>Can anyone help,?
>Large Systems Engineering & Messaging NC4IT
>Lowe's Companies, Inc.
>1000 Lowe's Boulevard
All information in and attached to the e-mail(s) below may be proprietary,
confidential, privileged and otherwise protected from improper or erroneous
disclosure. If you are not the sender's intended recipient, you are not
authorized to intercept, read, print, retain, copy, forward, or disseminate
this message. If you have erroneously received this communication, please
notify the sender immediately by phone
(704-758-1000) or by e-mail and destroy all copies of this message
(electronic, paper, or otherwise). Thank you.