topic Re: help on coding in SAS Procedures

help on coding

otis — Wed, 26 Jun 2013 16:00:07 GMT

This attribute, hist12, contains a 12-month history of delinquency. For example, 100000001000 indicates the most recent month and 9 months prior have delinquencies and all other months were current. I need to identify accounts with at least 1 delinquency in the last 12 months. What's the most efficient way to code it? I can use substr function to extract one byte at a time, but I would think there are better ways.

Thanks!

Re: help on coding

Reeza — Wed, 26 Jun 2013 16:15:34 GMT

Isn't that anything greater than 000000000000, 12 0's?

if hist12>'000000000000' then ...

Re: help on coding

otis — Wed, 26 Jun 2013 16:27:50 GMT

Thanks. That really helps. One thing I forgot to mention is that there is a value 'Z' represents inactivity. So it could look like: 10000zz00100. Your codes would include accounts with at least one delinquency in last 12 months or at least one inactivity ('Z') in last 12 months. How do I code it so I only have the first set?

Re: help on coding

Reeza — Wed, 26 Jun 2013 16:39:00 GMT

compress out the Z's....

Test is just to see the variable, you can delete that line.

data want;

set have;

test=input(compress(hist12, "z"), 12.);

if input(compress(hist12, "z"), 12.)>0 then flag=1;

else flag=0;

run;

Re: help on coding

Haikuo — Wed, 26 Jun 2013 16:47:16 GMT

If using compress() as Reeza suggested, you can as well just do the following:

data want;

set have;

flag=lengthn(compress(a,'z0'))>0;

run;

Haikuo

Re: help on coding

Tom — Wed, 26 Jun 2013 16:52:45 GMT

You could use the INDEXC() function or COUNTC() function.

if index(hist12, '1') then put 'Deliquent';

numdel = countc(hist12,'1');

firstdel = index(hist12,'1') ;

Re: help on coding

otis — Wed, 26 Jun 2013 18:02:55 GMT

Appreciate all the suggestions. They all worked. The easiest way in my situation is to use countc or index.