Date:         Sat, 28 Feb 2004 01:32:59 GMT
Reply-To:     Barry Schwarz <schwarzb@DELOZ.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Barry Schwarz <schwarzb@DELOZ.NET>
Subject:      Re: Range checking question
Content-Type: text/plain; charset=us-ascii

On 26 Feb 2004 15:30:03 -0800, mixiao@ucla.edu (miranda) wrote:

>Hi,
>I have a data field   RAN004 valuse  like nelow :
>
>RAN004
>
>01C
>04C
snip
>01c
>02c
>05B
>03B
>
>The range of  this field is 01A~99C,
>How could I check this field and report those  out of range value  like
>01F,03H,05G,03D,04K ?
>
>Thanks.

x1 = substr(ran004,1,1);
x2 = substr(ran004,2,1);
x3 = substr(ran004,3,1);
if x1 < '0' | x1 > '9' |
    x2 < '0' | x2 > '9' |
    x3 < 'A' | x3 > 'Z' then
...


<<Remove the del for email>>