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
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,
Washington State Department of Social and Health Services
Division of Research and Data Analysis (RDA)
From: Stephen Finnigan [mailto:sfinnigan@NATHANINC.COM]
Sent: Friday, June 08, 2001 8:38 AM
Subject: setting negatives to .
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
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
Stephen Finnigan firstname.lastname@example.org
Nathan Associates Inc. 703.516.7731