topic Re: index function in SAS Programming

index function

ieva — Wed, 06 May 2009 12:41:37 GMT

Hi,

Maybe someone of you knows - is there a function similar to index, only working from right side to left (not left to right as index does).

For example, in this case index is 3 and 4. But I would like to find which position counting from right side when first time appears '1' (that would be 2 and 5).

data b;
input a $8.;
index=index(a, '1');
datalines;
00101110
00010000
;
run;

Thanks for your ideas,
Ieva Message was edited by: ieva

Re: index function

sbb — Wed, 06 May 2009 13:04:35 GMT

Explore the FIND function using a negative large-value (or a LENGTH() function) for the starting position.

Scott Barry
SBBWorks, Inc.

Re: index function

ieva — Wed, 06 May 2009 13:30:27 GMT

Thank you, this works as expected!