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
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: