topic Re: Multiple values in a Macro variable in SAS Programming

Multiple values in a Macro variable

Ivy — Fri, 06 Jan 2017 17:08:54 GMT

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 — Fri, 06 Jan 2017 17:23:34 GMT

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

Hope it helps.

Daniel Santos @ www.cgd.pt

Ivy — Fri, 06 Jan 2017 18:43:56 GMT

Thank you very much, that works !