topic Test for certain numeric values in SAS Procedures

Test for certain numeric values

sasbanker — Mon, 18 May 2015 13:19:07 GMT

I have two Char fields with a length of 10, named "Acct" and "Derived".

I need to test the "Acct" field, and if the value has a length of 6, and is a numeric value between 100,000 & 999,999, then copy the value to the "Derived" field.

How to code the Update statement?

Sample data looks like this:

Acct

==========

100

1000A

201000 ==> Copy

210000A

312456 ==> Copy

A400010

I'm a newbie just learning, so please be specific in your response.i

Re: Test for certain numeric values

naveen20jan — Mon, 18 May 2015 14:16:59 GMT

Hi ,

You can try the below approch ;

data want ;

set have ;

if notdigit(acct) = 0 and lenght(acct) = 6 and 100000 =<acct >=999999 then derived = acct ;

run;

Re: Test for certain numeric values

Ksharp — Mon, 18 May 2015 14:20:31 GMT

data have;

input acct $;

cards;

100

1000A

201000

210000A

312456

A400010

;

run;

data want ;

set have;

length derived $ 10;

if 100000<=input(acct,?? best32.)<=999999 then derived=acct;

run;

Re: Test for certain numeric values

RW9 — Mon, 18 May 2015 14:30:21 GMT

Just to note, you don't actually need to check the length there:

if notdigit(acct) = 0 and 100000 =<acct >=999999 then derived = acct ;

As anything not between the given upper and lower includes those with a length ne 6.