topic Re: passing string to macro and using bquote in SAS Programming

passing string to macro and using bquote

csetzkorn — Thu, 26 Apr 2018 13:22:16 GMT

Can someone please help with this code. It looks OK to me:

%macro SomeExcitingMacro(Origin);
	PROC SGPLOT DATA=SASHELP.cars(where=(Origin = %bquote('&Origin.')));
	  VBOX Invoice
	  / category = DriveTrain nooutliers;
	   title &Origin.; 
	RUN;
%mend SomeExcitingMacro;

%SomeExcitingMacro(Asia);

I get this error:

ERROR: Syntax error while parsing WHERE clause.

Re: passing string to macro and using bquote

Astounding — Thu, 26 Apr 2018 13:28:29 GMT

WHERE is fussy about parsing quoted strings But why use that complication at all? Why not just:

(where=(Origin="&Origin."))

There's no apparent reason for %BQUOTE here.

Re: passing string to macro and using bquote

RW9 — Thu, 26 Apr 2018 13:32:21 GMT

To resolve a macro reference you need to use double quotes. But I don;t see why your using bquote at all?

%macro someexcitingmacro (origin);
  proc sgplot data=sashelp.cars;
   where origin="&origin.";
   vbar invoice / category=drivetrain nooutliers;
   title "&origin."; 
  run;
%mend someexcitingmacro;

%someexcitingmacro(Asia);

You will note I changed some cases and things, nobody likes being shouted at.

Re: passing string to macro and using bquote

csetzkorn — Thu, 26 Apr 2018 13:30:31 GMT

Mmm .. it worked in other scenarios but you are right simpler is better (-: