Andrea,

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=.;

Regards,

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. > >