I have a store process code with two GCHART procedures & two TABULATE Procedures. (e.g. SASHELP.CLASS with sex ="F" and sex="M").
I am using it in SAS BI Dashboard 4.3 (SAS 9.2) windows application. I have defined a spark table, and an indicator with a link to this store process.
When USER CLICKS ON SPARK TABLE COLUMN, it creates only a PNG file for the first GCHART procedures and displays the GCHART output in a new window.
It doesn't create first tabulate report and second GCHART/TABULATE outputs.
How can I have both, two GCHART & two TABULATE output being pushed as an output through Store Process ?
When user clicks on a spark table column, I would like to see/show/display all in a new window.
First GCHART : Where sex='F" and First TABULATE OUTPUT Where sex='F"
Second GCHART : Where sex='M" and Second TABULATE OUTPUT Where sex='M"
How can I accomplish it?
Thanks,
Girish Patel
Upon adding %stpbegin and %stpend in the store process (with prompts), I was able to achive desired functionality.
I used and linked store process to SAS BI Dashboard Indicators (defined in a spark table), to display the results of Proc GChart and Proc Tabulate in a new window.
Solved.
Thanks,
Girish Patel
Great news Girish. I was just getting ready to respond!
My tip is always to test the stored process code from the SAS Stored Process Web Application first to ensure that it works as expected without bringing other components (such as BI Dashboard) into the mix.
~ Angela
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
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.