topic Re: Store process work around in Developers

Store process work around

GPatel — Mon, 11 Jun 2012 23:39:19 GMT

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

Re: Store process work around

GPatel — Fri, 15 Jun 2012 13:16:39 GMT

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

Re: Store process work around

AngelaHall — Fri, 15 Jun 2012 17:55:51 GMT

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

http://blogs.sas.com/content/bi