Macro paramter parsing from another string

[ger15xxhcker]

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!

[PeterClemmensen · Accepted solution]

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

[ger15xxhcker]

Thanks for your help

[PeterClemmensen]

Anytime 🙂

[Tom]

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