topic how can I automatically count the number of items in a macro variable? in SAS Programming

how can I automatically count the number of items in a macro variable?

Jiawenabby8 — Fri, 23 Feb 2018 00:31:47 GMT

Hi,

I would like to know how to automatically determine the number of items in & type(=26) instead of declaring 26 in the below script....
Just a very simple example:

%let type= A B C D E F G H I J K L M N O P R S T U V W X Y Z ;

data _NULL_;

do i = 1 to 26; <---- this value of 25 is what I would like to automate when I change &type.

put Number=i ;

end;

run;

Re: how can I automatically count the number of items in a macro variable?

ChrisBrooks — Fri, 23 Feb 2018 00:38:47 GMT

Assuming they're always space separated then the countw function should do the trick like so

%let type= A B C D E F G H I J K L M N O P R S T U V W X Y Z;
data _NULL_;
do i = 1 to countw("&type");  
put Number=i ;
end;
run;

Re: how can I automatically count the number of items in a macro variable?

Reeza — Fri, 23 Feb 2018 01:13:21 GMT

This may be a useful example for you:

http://documentation.sas.com/?docsetId=mcrolref&docsetTarget=n1qvxz5u3uru7yn1nk7q64ohvwak.htm&docsetVersion=9.4&locale=en

and some more are here:

http://documentation.sas.com/?docsetId=mcrolref&docsetTarget=n02xowj8yuqfo4n0zzi98shu8qup.htm&docsetVersion=9.4&locale=en

Re: how can I automatically count the number of items in a macro variable?

Jiawenabby8 — Fri, 23 Feb 2018 15:34:50 GMT

Your links are super helpful. Thanks so much!