Multiple values in a Macro variable

[Ivy]

Hello ,

May you help me to check how I should correct the following Macro statements? &med cannot provide me the correct value. 😞 

%let medlist = %str("cisplatin" ; "carboplatin"; "paclitaxel" ; "paclitaxel protein-bound" ; "pemetrexed disodium" );

%let med = %scan(&medlist, 4, ";") ;

%put &medlist &med ;

Thank you,

Ivy

[Daniel-Santos · Accepted solution]

Hi.

Remove the " around ;

%let med = %scan(&medlist, 4, ;) ;

The third argument of the SCAN function is a list of characters considered to be separators, any of them will be identified as a separator.

If you want to remove the quotes around the item use dequote function, like this:

%let med = %sysfunc(dequote(%scan(&medlist, 4, ;))) ;

More on the SCAN function here: http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000214639.htm

Hope it helps.

Daniel Santos @ www.cgd.pt

[Ivy]

Thank you very much, that works !