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;
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;
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;
This may be a useful example for you:
and some more are here:
Your links are super helpful. Thanks so much!
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.