topic Re: Index function strange behaviour in SAS Programming

Index function strange behaviour

garag — Fri, 22 Nov 2013 10:59:48 GMT

Hi,

running the following code:

%macro boh;

data _null_;
    a="aaaaBIANNUAL";
    b="BIANNUAL";
    q=index(a,b);
    w=index(a,trim(b));
    put q= w=;
run;

%put %index("aaaaBIANNUAL", %trim("BIANNUAL")) ;

%mend;
%boh;

I get this result:

q=5 w=5

it semmes that the function index work in two different way if used in a data step or in a macro (in the datastep in a correct wat, in the macro does not work)

Does someone know the reason?

Many thanks.

Bye

Antonio

Re: Index function strange behaviour

Peter_C — Fri, 22 Nov 2013 11:08:32 GMT

take the quotes out of the %put statement and try again.

Message was edited by: Peter Crawford Should clarify the statement to change

Re: Index function strange behaviour

ballardw — Fri, 22 Nov 2013 19:05:07 GMT

Macro functions generally are text manipulators and do NOT require the quotes to distinguish between variable names and string literals as in a datastep. If you put a quote in any of the argument strings it is treated as being a part of the string. So "BIANNUAL" is not part of aaaaBIANNUAL in any way.