topic Re: quotes to macro variable string in SAS Programming

quotes to macro variable string

West26 — Mon, 28 Sep 2020 00:26:38 GMT

Hello,

The below resolution from our community, works perfectly for macro variables separated by blanks

%let mvar=aaaaa bbbbb ccccc zzzzz;

%let mvar_quotes=%nrbquote(')%qsysfunc(prxchange(s/\s+/%nrbquote(',')/oi,-1,&mvar))%nrbquote(');

%put mvar_quotes: %bquote(&mvar_quotes);

resolution:

mvar_quotes: 'aaaaa','bbbbb','ccccc','zzzzz'

But I do have the %let as

%let mvar=aa-aa-a,bbbb-b,c-cccc,zzz-zz (where the variables are alreadu seperated by a ',')

I need quotes for the variables separated by ',' which means I need the resolved macro variables like beow.

mvar_quotes: 'aa-aa-a','bbbb-b','c-cccc','zzz-zz'

I have tried modifying the above resolution stmt, but couldn't succeed. Pls help

Re: quotes to macro variable string

ChrisNZ — Mon, 28 Sep 2020 01:34:01 GMT

This will work whether the separator is a space or a comma:

%let mvar=aa-aa-aaaaaaaa bbbb-b,c-cccc,zzz-zz;

%let list = %str(%')%qsysfunc(prxchange(%str(s/\s|,/','/),-1,%superq(mvar)))%str(%');
%let list = %unquote(&list);

data T; do A=&list.; putlog A=; end; run;

A=aa-aa-aaaaaaaa
A=bbbb-b
A=c-cccc
A=zzz-zz

Re: quotes to macro variable string

West26 — Mon, 28 Sep 2020 01:48:10 GMT

Hello Chris,

I do appreciate for the quick response. It resolved the issue.

Thank you.