topic Re: Scan Function in SAS Procedures

Scan Function

sam369 — Wed, 24 Apr 2013 15:05:48 GMT

Hi Experts,

i got an issue while iam using scan function. i want to seperate the string with delimeter.

example is below:

%let varlist=ficc <100 ficc 100-400 ficc >400;

%macro test;

%do i=1 to 3;

%let test=%sysfunc(scan(&varlist,&i,' '));

%put &test=;

%end;

%mend;

%test;

got an errors saying scan have too many arguments ,some time uninitilized

want:

test=ficc <100

test=ficc 100-400

test=ficc >400

Thanks

Sam

Re: Scan Function

Reeza — Wed, 24 Apr 2013 15:15:58 GMT

you need a %to in your do loop.

There's many ways to do this, but if you know you always need the ficc why not scan with that as the delimiter instead and always add it in?

%let varlist=ficc <100 ficc 100-400 ficc >400;

%macro test;

%do i=1 %to 3;

%let test=%sysfunc(scan(&varlist,&i,'ficc'));

%put test= ficc &test;

%end;

%mend;

%test;

Re: Scan Function

Ksharp — Wed, 24 Apr 2013 15:21:13 GMT

a blank is a special character for Macro compiler. you need add %str () around it.

%let varlist=ficc <100 ficc 100-400 ficc >400;

%macro test;

%do i=1 %to 6 %by 2;

%let test=%scan(&varlist,&i,%str( ));

%let test1=%scan(&varlist,%eval(&i+1),%str( ));

%put &test &test1 ;

%end;

%mend;

%test

Ksharp

Re: Scan Function

sam369 — Wed, 24 Apr 2013 15:47:41 GMT

Thank you Reeza and Ksharp!!!!! Thanks for the details....

Ksharp it really Good to see you back!!!!!

Sam

Re: Scan Function

robertrao — Wed, 24 Apr 2013 19:46:53 GMT

1)is %str( ) used here for the spaces between the names in the variable list???

a blank is a special character for Macro compiler. you need add %str () around it.

%let varlist=ficc <100 ficc 100-400 ficc >400;

%macro test;

%do i=1 %to 6 %by 2;

%let test=%scan(&varlist,&i,%str( ));

2)firstly how can the variables in a dataset be named like this(with a space in between???)??

is that allowed???

ficc <100

Thirdly,

test=%sysfunc(scan(&varlist,&i,'ficc'));

if we use ficc as a delimiter then wont it be eliminated????

when we say a delimiter is a space then it means space seperated the two words...

same way here is it not like telling ficc spereatess two words???

Re: Scan Function

Reeza — Wed, 24 Apr 2013 20:52:08 GMT

Who said anything about variable names?

You can do it though, using it with options validvarname=any;

then you reference it 'ficc <100'n

Re: Scan Function

robertrao — Wed, 24 Apr 2013 21:00:11 GMT

I am sorry about the confusion.

Thanks

Re: Scan Function

Ksharp — Thu, 25 Apr 2013 02:47:55 GMT

1)is %str( ) used here for the spaces between the names in the variable list???

Yes.

Re: Scan Function

Ksharp — Thu, 25 Apr 2013 02:56:04 GMT

Thanks. I am happy to here too . Hope I could always be here . Guys!