LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (December 2005, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Mon, 12 Dec 2005 10:01:27 -0600
Reply-To:     Gregg Snell <gsnell@DATASAVANTCONSULTING.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Gregg Snell <gsnell@DATASAVANTCONSULTING.COM>
Organization: Data Savant Consulting
Subject:      Re: how to treat 99 or 9999 as missing?
In-Reply-To:  <BAY101-F111A6831B709384467355BDE460@phx.gbl>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed


By "treat as null" are you referring to a SAS PROC? If so, then I believe your only option is to recode the variables as they are read from the flat file, i.e. input var1 var2; if var2=99 then var2=.;


Gregg P. Snell

> > From: "Wainwright, Andrea" <andrea.wainwright@CAPITALONE.COM> > Reply-To: "Wainwright, Andrea" <andrea.wainwright@CAPITALONE.COM> > To: SAS-L@LISTSERV.UGA.EDU > Subject: how to treat 99 or 9999 as missing? > Date: Mon, 12 Dec 2005 10:32:37 -0500 > > I know there is an option, but am not sure what it is. > > We have a situation with a flat file that contains a 99 or a 9999 when > it should be null. We don't seem to be able to get around this. > > There is a known list of attributes where 99 or 9999 should be treated > as null, but there are other fields where that is a valid value. > > Is there an option for just these variables that will treat it as null, > but leave the value alone in other fields? > > > > > > > > The information contained in this e-mail is confidential and/or > proprietary > > to Capital One and/or its affiliates. The information transmitted > herewith > > is intended only for use by the individual or entity to which it is > > addressed. If the reader of this message is not the intended recipient, > > you are hereby notified that any review, retransmission, dissemination, > > distribution, copying or other use of, or taking of any action in > reliance > > upon this information is strictly prohibited. If you have received this > > communication in error, please contact the sender and delete the material > > from your computer. > >

Back to: Top of message | Previous page | Main SAS-L page