BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
pink_poodle
Barite | Level 11

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

 

SAS Stored Processes: Input Parameters

1 ACCEPTED SOLUTION

Accepted Solutions
Cynthia_sas
Diamond | Level 26
HI: I remember an example of a stored process in the sample library, that had something like this. When you clicked on a graph, it drilled down to the data behind the graph. You might want to check the Stored Process documentation and the samples for the Stored Process Web Application. Look here: https://support.sas.com/documentation/onlinedoc/inttech/9.3/stpex.pdf at example 2.4.

Cynthia

View solution in original post

1 REPLY 1
Cynthia_sas
Diamond | Level 26
HI: I remember an example of a stored process in the sample library, that had something like this. When you clicked on a graph, it drilled down to the data behind the graph. You might want to check the Stored Process documentation and the samples for the Stored Process Web Application. Look here: https://support.sas.com/documentation/onlinedoc/inttech/9.3/stpex.pdf at example 2.4.

Cynthia

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Register now

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 1107 views
  • 1 like
  • 2 in conversation