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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.