Macro for multiple sgplot output but all identical

[Michaelcwang2]

Dear all,

Following my last trial to output a series of histogram through SQL with different parameters and SAS code as attached.

%MACRO SPCDIST;  /*Macro file is needed for repetitive SQL statement*/
%do j=1 %to 10;
PROC SQL;
   CREATE TABLE work.query AS
   SELECT j , i , X , Y FROM MYSECOND.SPC; 
   WHERE J=&j AND Y=0;
   RUN;
   QUIT;
   
   ods graphics / reset imagemap;

   /*--SGPLOT proc statement--*/
   proc sgplot data=WORK.QUERY;
	/*--Histogram settings--*/
	
	histogram X /;

	/*--Vertical or Response Axis--*/
	yaxis grid;
	
   run;
   /*end;
   run;*/
   

   ods graphics / reset;
%end;
%MEND;
%SPCDIST;

The result was output 10 identifical plots (like j=10). I wonder where went wrong and please advise.

Thank you!

[ShiroAmada · Accepted solution]

You closed your proc sql step too soon.  Correct the sql step, save then rerun.  Try this one....

PROC SQL;
   CREATE TABLE work.query AS
   SELECT j , i , X , Y FROM MYSECOND.SPC 
   WHERE J=&j AND Y=0;
   RUN;
   QUIT;

hope it helps.

[Michaelcwang2]

Dear ShiroAmada,
Thank you and you are right! Now it works for ten different charts. Highly appreciated!