topic Re: Difference in positions in SAS Programming

Difference in positions

light — Mon, 11 Apr 2016 23:52:15 GMT

Hello 🙂

There is a statement: "Apple is the Anthem"

How do I write a step that finds the difference in positions between the two As?

THANK YOU!!!!

Reeza — Tue, 12 Apr 2016 00:57:49 GMT

Well, you could use the index function to find each A and then subtract but that doesn't scale well.

Will you always be looking for two As?

It looks like your doing string functions. You may want to review the available functions here

Ksharp — Tue, 12 Apr 2016 01:39:34 GMT

Just two A ?

data _null_;
x="Apple is the Anthem";
a=findc(x,'A');
b=findc(x,'A','b');
dif=b-a;
put a= b= dif=;
run;

light — Tue, 12 Apr 2016 02:04:38 GMT

Hi Ksharp,

Works perfectly!

Thank you for your sharp advice 🙂

light — Tue, 12 Apr 2016 02:05:22 GMT

Hi Reesa,

I will review these! Thank you greatly !!