topic Re: Why the macro in not giving any output? in SAS Data Science

Why the macro in not giving any output?

devarayalu — Wed, 06 Nov 2013 08:13:01 GMT

Can any one help me here?

%macro one;

%if %index("devara", "deva") %then %put exists;

%mend;

%one;

Thank you in advance

Re: Why the macro in not giving any output?

Jagadishkatam — Wed, 06 Nov 2013 08:33:46 GMT

the above macro is working, however since the index function is unable to find the text "deva" including the quotes in "devara" it is not displaying anything in the log. Please try the below code and check the log you will find not exists in the log.

%macro one;

%if %index("devara", "deva") %then %put exists;

%else %put not exists;

%mend;

%one;

Re: Why the macro in not giving any output?

ballardw — Wed, 06 Nov 2013 15:50:48 GMT

Also confusing the rules for strings between macro and datastep code.

Try using this line:

%if %index(devara, deva) %then %put exists

Macro literals do not need quotes to delimit but data step string literals do. Since macro variables would be reference by &var then without the & the macro processor treats what follows as string literal.

And you original code failed because "deva" did not occur within the source string.