topic Re: Macro program in SAS Programming

Macro program

Ivy — Fri, 06 Jan 2017 20:40:44 GMT

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;

Re: Macro program

Reeza — Fri, 06 Jan 2017 20:46:49 GMT

What error do you get?

Re: Macro program

Patrick — Fri, 06 Jan 2017 21:00:44 GMT

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(;) );

Re: Macro program

ballardw — Fri, 06 Jan 2017 21:01:08 GMT

%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?

Re: Macro program

Ivy — Fri, 06 Jan 2017 21:07:25 GMT

Dear all,

Thank you very much,

%str() works so beautifully ! 🙂

Ivy

Re: Macro program

Patrick — Fri, 06 Jan 2017 22:13:39 GMT

@Ivy

Then please mark one of the answers as correct answer