%scan

[Siddharth123]

Hi All,

%let m=delhi, 1;

data test;

m1=%scan(&var,1,%bquote(,));

proc print;

run;

I want that m1 takes value delhi in the data step. Please suggest.

Regards

SK

[FredrikE]

why not just use scan?

m1=scan(&m",1,',');

[Siddharth123]

Hi Fredrik,

It doesnt work, I could have used that but if you take a look at the macro parameter then it creates a new variable called delhi which is the first occurence in the macro 'm and something that is not desired.

Regards

SK

[FredrikE · Accepted solution]

so you want m1 to get the value from the variabel delhi and not the value "delhi"?

Like this?

%let m=delhi, 1;

data test;
delhi = 'Aruba';
m1=%scan(&m,1);

proc print;

run;

[Siddharth123]

perfect!