topic How to use a macro variable in index function? in SAS Programming

How to use a macro variable in index function?

Shayan2012 — Thu, 24 Jul 2014 18:02:26 GMT

Hi all,

So, I am trying to search for some strings in a text, and I want to use the strings with macro variable so I be able to change the string. However, I am not sure how to use the macro variable in the index function.

For example,I am doing such thing:

%let str=William;

y=index(line,&str);

Is this the correct form since there are no ' ' around the variable &str? I am asking this because I see the SAS does not find the specified string in the text, although I know it is there.

I will be grateful if someone helps me.

Thanks a lot,

Re: How to use a macro variable in index function?

stat_sas — Thu, 24 Jul 2014 18:09:14 GMT

%let str=William;

y=index(line,"&str");

Re: How to use a macro variable in index function?

jakarman — Thu, 24 Jul 2014 18:14:09 GMT

When you are working with text-string in an SAS-macro environment look at the sas-macrofunctions (they all start with a %)

When you are using SAS-macro variables in a sas-datastep and process those in a string make sure there quotes. '

The macro-variable itself can contain quotes

%let str='William';

y=index(line,&str);

or use the double quotes to indicate the & are sasmacro-variables to be resolved. (Single quotes will cause no resolving of macros)

%let str=William;

y=index(line,"&str");

Re: How to use a macro variable in index function?

Shayan2012 — Thu, 24 Jul 2014 21:05:21 GMT

Thanks a lot guys!