topic Re: interate a list so that there is a dot in the name of the items in the list in SAS Programming

interate a list so that there is a dot in the name of the items in the list

ger15xxhcker — Wed, 09 Mar 2022 11:18:48 GMT

Hi!

I want to go through the elements of a list but there is a dot in the name of the elements of the list and there it separates the elements of the list I only want to separate them along the spaces.

%macro px;

%let value = x.yy a.yy;
%local i next_value;
%let i=1;
%do %while (%scan(&value, &i) ne );
   %let next_value = %scan(&value, &i);
%put &next_value;
%let i = %eval(&i + 1);
%end;

%mend;

%px;

I get this :

I want this:

x.yy

a.yy

Thanks!

Re: interate a list so that there is a dot in the name of the items in the list

PaigeMiller — Wed, 09 Mar 2022 11:35:09 GMT

You have to specifically tell the SCAN function to only use spaces as word delimiter, and not spaces plus periods plus other special symbols (which is the default). Modify these two lines as shown

%do %while (%scan(&value, &i) ne %str( ));
   %let next_value = %scan(&value, &i, %str( ));

Re: interate a list so that there is a dot in the name of the items in the list

ger15xxhcker — Wed, 09 Mar 2022 11:37:46 GMT

Thanks! Works fine.