BookmarkSubscribeRSS Feed
Pyrite | Level 9

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?


Girish Patel

Pyrite | Level 9

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.



Girish Patel

SAS Employee

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. 

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.

Get the $99 certification deal.jpg



Back in the Classroom!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 2 in conversation