topic Re: Calculating length of a variable in New SAS User

Calculating length of a variable

zishaq — Fri, 13 Sep 2019 13:44:47 GMT

Hello,

I'm hoping somebody can help me out with something that seems fairly simple!

I have a character variable called 'Emp' which is 12 characters long and contains the numbers 1 and 0 only. For example;

111111111111

110111111111

111111111110

011111111111

011011110110

I am trying to work out the difference between the position of the first '1' and the last '1' for each row. The answers should be 11 (for the 1st row), 11 (for the 2nd row), 10 (for the 3rd row), 10 (for the 4th row) and 9 (for the 5th row).

Can somebody help me put this in to a code without having to go through each line manually?

Thank you

Re: Calculating length of a variable

novinosrin — Fri, 13 Sep 2019 13:49:47 GMT

Fun stuff

Hi @zishaq

data have;
input str $12.;
cards;
111111111111
110111111111
111111111110
011111111111
011011110110
;

data want;
set have;
first=findc(str,'1');
last=findc(str,'1','b');
want=last-first;
run;

Re: Calculating length of a variable

PaigeMiller — Fri, 13 Sep 2019 13:54:33 GMT

data want;
    set have;
    length_of_string=length(x);
    first_one=find(x,'1');
    last_one=length_of_string-find(reverse(x),'1')+1;
    distance=last_one-first_one;
run;

Re: Calculating length of a variable

zishaq — Fri, 13 Sep 2019 14:00:05 GMT

Thanks a lot!