topic Re: Macro paramter parsing from another string in SAS Programming

Macro paramter parsing from another string

ger15xxhcker — Tue, 05 Apr 2022 10:16:40 GMT

Hi!

For some reason the first parameter reads the whole string is not separated by a comma. How can I solve this?

%macro mmm(p_aram,p_aram2);
%put >>> &p_aram.;
%put >>> &p_aram2.;
%mend;

%let x="x,y";
%let x = %qsysfunc(compress(&x,%str(%")));
%put &x.;
%mmm(%str(&x.));

I want p_aram = x p_aram2 = y

Thanks!

Re: Macro paramter parsing from another string

PeterClemmensen — Tue, 05 Apr 2022 10:31:59 GMT

Use Sysfunc instead of Qsysfunc

%macro mmm(p_aram,p_aram2);
%put >>> &p_aram.;
%put >>> &p_aram2.;
%mend;

%let x="x,y";
%let x = %sysfunc(compress(&x,%str(%")));
%put &x.;
%mmm(%str(&x.));

Re: Macro paramter parsing from another string

ger15xxhcker — Tue, 05 Apr 2022 10:39:47 GMT

Thanks for your help

Re: Macro paramter parsing from another string

PeterClemmensen — Tue, 05 Apr 2022 10:40:13 GMT

Anytime 🙂

Re: Macro paramter parsing from another string

Tom — Tue, 05 Apr 2022 14:02:10 GMT

Sounds like the issue is you are macro quoting the value, so the comma is "protected".

%let x="x,y";
%mmm(%sysfunc(dequote(&x)));

Is there some reason why you thought you needed to add macro quoting?

In that case use %QSCAN() to pick off the first and second values.

%let x="x,y";
%let x=%qsysfunc(dequote(&x));
%mmm(%qscan(&x,1,%str(,)) , %qscan(&x,2,%str(,));