This question is inspired by the following topic about Stored Processes @CLE:
SAS-Stored-Processes/Sgplot-with-drill-down-links-to-another-stored-process-and-pass
Can you drill down on a point on a graph by simply clicking that point? In Python GUI, getMouse( ) method can fetch the coordinates where the user clicks the mouse in the graphics window. It would be nice, for example, to get &MONTH and &YEAR for a stored process this way.
*ProcessBody;
%stpbegin;
title "Product Sales for &MONTH, &YEAR";
proc print data=sales;
where Month eq "&MONTH" and Year eq &YEAR;
var productid product sales salesgoal;
run;
%stpend;
Reference
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
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.
Ready to level-up your skills? Choose your own adventure.