topic Macro for multiple sgplot output but all identical in SAS Programming

Macro for multiple sgplot output but all identical

Michaelcwang2 — Mon, 18 Sep 2017 05:42:02 GMT

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!

Re: Macro for multiple sgplot output but all identical

ShiroAmada — Mon, 18 Sep 2017 07:21:16 GMT

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.

Re: Macro for multiple sgplot output but all identical

Michaelcwang2 — Mon, 18 Sep 2017 07:39:49 GMT

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