Date: Fri, 8 Jun 2001 09:27:15 -0700
Reply-To: "Terjeson, Mark" <TerjeMW@DSHS.WA.GOV>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Terjeson, Mark" <TerjeMW@DSHS.WA.GOV>
Subject: Re: setting negatives to .
Content-Type: text/plain; charset=iso-8859-1
Hi Stephan,
Certainly we could change the values, but if I'm reading your
question right you say "How do I make the negatives *appear*
as . without losing a numeric format such as percent8.2?".
Sounds like you want to keep the negative values, and just not
have them "appear"? Or you may mean keep the percent8.2
and blow away the negs and just let the positives stay.
If you are thinking "keep data" and make it *appear* the way you
want then how about a PICTURE format which can have
different ranges and picture formats. (where are those PICTURE
format guru's when you need one. [hey, Pete Lund, get back from
the Seattle SI branch office and answer this man's question!]) :o)
Hope this is helpful,
Mark Terjeson
Washington State Department of Social and Health Services
Division of Research and Data Analysis (RDA)
mailto:terjemw@dshs.wa.gov
-----Original Message-----
From: Stephen Finnigan [mailto:sfinnigan@NATHANINC.COM]
Sent: Friday, June 08, 2001 8:38 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: setting negatives to .
Hello everyone.
Here's a quickie (though not for me... ). How do I go about setting (either
permanently or through a format) negative values in a dataset to . ? Easy
enough if my data were friendly, however, the data I have has a large (and
via iteration, varying) number of variables and I am looking for a clean
solution.
Specifically: How do I make the negatives appear as . without losing a
numeric format such as percent8.2?
YR _1 _2 _3 _4
90 .20 .25 .30 .30
91 .15 .22 .28 .25
92 .05 .20 .22 .10
93 -.05 .20 .20 -.10
94 -.03 .22 .24 -.05
95 .05 .25 .26 .02
Thanks!
__________________________________________________
Stephen Finnigan sfinnigan@nathaninc.com
Nathan Associates Inc. 703.516.7731
