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!
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.
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.