passing string to macro and using bquote

[csetzkorn]

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.

[Astounding · Accepted solution]

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.

[csetzkorn]

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

[RW9]

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.