DATA Step, Macro, Functions and more

Macro for multiple sgplot output but all identical

Accepted Solution Solved
Reply
Contributor
Posts: 23
Accepted Solution

Macro for multiple sgplot output but all identical

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!


Accepted Solutions
Solution
‎09-18-2017 03:38 AM
Frequent Contributor
Posts: 113

Re: Macro for multiple sgplot output but all identical

Posted in reply to Michaelcwang2

 

 

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.

View solution in original post


All Replies
Solution
‎09-18-2017 03:38 AM
Frequent Contributor
Posts: 113

Re: Macro for multiple sgplot output but all identical

Posted in reply to Michaelcwang2

 

 

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.

Contributor
Posts: 23

Re: Macro for multiple sgplot output but all identical

Posted in reply to ShiroAmada
Dear ShiroAmada,
Thank you and you are right! Now it works for ten different charts. Highly appreciated!
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 146 views
  • 0 likes
  • 2 in conversation