Hello,
When I put the following Macro statments in a loop in Macro program, it gave me error , however, I can run by itself without probelm. I I am wondering what is the problem.
Thank you.
%let medlist = %str("cisplatin" ; "carboplatin"; "paclitaxel" ; "paclitaxel protein-bound" ; "pemetrexed disodium"; "ramucirumab"; "bevacizumab" ; "pembrolizumab" ; "nivolumab" ; "necitumumab" );
%let med = %scan(&medlist, 8 , ; );
%macro test1;
%let medlist = %str("cisplatin" ; "carboplatin"; "paclitaxel" ; "paclitaxel protein-bound" ; "pemetrexed disodium"; "ramucirumab"; "bevacizumab" ; "pembrolizumab" ; "nivolumab" ; "necitumumab" );
%do i =1 %to 10 ;
%let med = %scan(&medlist, &i , ; );
%put &med ;
%end;
%mend;
%test1;
NOTE: One or more missing close parentheses have been supplied for the %SCAN function.
Put the ; delimiter into a %str() function so it doesn't get interpreted as end of command indicator.
%let med = %scan(&medlist, &i , %str(;) );
What error do you get?
NOTE: One or more missing close parentheses have been supplied for the %SCAN function.
Put the ; delimiter into a %str() function so it doesn't get interpreted as end of command indicator.
%let med = %scan(&medlist, &i , %str(;) );
%let med = %scan(&medlist, &i , %str(;) );
The "bare" semicolon is treated as a statement ender. I would consider use of a ; as a delimiter a poor choice for working with SAS code. Is there a specific reason you used that?
Dear all,
Thank you very much,
%str() works so beautifully ! 🙂
Ivy
Then please mark one of the answers as correct answer
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.