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

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