topic Re: %scan in SAS Procedures

%scan

Siddharth123 — Tue, 15 Oct 2013 05:42:41 GMT

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

Re: %scan

FredrikE — Tue, 15 Oct 2013 05:57:28 GMT

why not just use scan?

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

Re: %scan

Siddharth123 — Tue, 15 Oct 2013 06:15:02 GMT

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

Re: %scan

FredrikE — Tue, 15 Oct 2013 06:26:40 GMT

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;

Re: %scan

Siddharth123 — Tue, 15 Oct 2013 06:32:57 GMT

perfect!