Jeema Tracker

How to create a data table connected to a graph

Jeema — Thu, 31 Jul 2014 08:28:56 GMT

I have a Query regarding my code for a graph created in SAS.(PFA the html output for the same)

I have created a CBEMA curve graph in Base SAS. This chart generates events (data points) dynamically in a particular time frame.

My program generates an animated gif to show data events occuring dynamically.

Requirement:

My requirement now is that I want a data table above the graph, populated with the latest event(data point) generated on the graph.
I managed to generate the table, but as you can see in the attached html output, the table is getting created over the chart. I want the table to be aligned properly above the graph and the chart below it.

Code functioning:
I have annotated the Cbema curve and the Data table separately in the code and have set both the annotated tables in one table named “anno_all “ and have called it in the proc gchart procedure.

According to my knowledge because of this my table is getting created over the chart.

So I want to know if it’s possible to call both the annotated tables(annocbema and anno_table) separately in the graph?

Is there any other method with which I can achieve my requirement.

Pasting below the macro I created to generate the attached graph:

%macro iterate;
data _null_;
if 0 then set work.cbema nobs=nobs;
call symput ('n',nobs);
run;
%do i=1 %to &n;
data read&i (drop=Account);
set work.cbema (obs=&i);
run;
proc sql print;
create table events as
select Duration, Magnitude, Event from read&i;
quit;
if Account="read&i";
data anno_table; set events;
length text $10;
function ="frame"; output;
xsys='3'; ysys='5'; hsys='1'; size=4; when='a'; function='label';
y=100-_n_*5;
x=5; position='1'; text=trim(left(Duration)); output;
x=15; position='2'; text=trim(left(Magnitude)); output;
x=25; position='3'; text=trim(left(Event)); output;
run;
data anno_all; set anno_table annocbema;
run;
proc gplot data=read&i;
plot magnitude*duration / annotate = anno_all haxis = axis1 vaxis = axis2 html=tips1;
plot2 magnitude*incident /
haxis = axis1 vaxis = axis2 html=tips1/*noframe*/
autovref cvref=graydd
autohref chref=graydd

des="" name="&name" ;

run;

output;
%end;
%mend;

Any kind of help will be appreciated.

Thanks

Re: SAS BI Dashboard viewing offline

Jeema — Mon, 21 Jul 2014 06:37:07 GMT

Thanks all and it really helped me resolve my query.

SAS BI Dashboard viewing offline

Jeema — Wed, 02 Jul 2014 09:36:40 GMT

I have a dashboard created in SAS BI Dashboard tool after importing the required data from excel.

I would like to know if we can view this dashboard offline? If yes, How can this be achieved?

Auto refreshing charts based on each iteration of a loop

Jeema — Mon, 23 Jun 2014 07:38:38 GMT

I would like to create a dynamic chart where the graph is refreshed in between short time intervals of say 5 seconds with different events plotted on the chart.

I have created a macro that creates a separate dataset for each event and within the macro have provided the plot graph function. So for each iteration(i.e each event) there will be a graph created.
Below is the described code I have created in Base SAS.But I am getting say 7 graphs for 7 events on the same page,wherein I want only a single graph to refresh every 5 seconds with the latest iterated event.
Any help for the code change below will be appreciated.

proc sql noprint;
   select count(distinct Event)
      into :n
      from Utildem.CbemaLabel;
   select distinct Event
      into :Event1 - :Event%left(&n)
      from Utildem.CbemaLabel;
quit;

%macro makeds;
   %do i=1 %to &n;
      data &&Event&i (drop=Event);
         set work.cbema;

         if Event="&&Event&i";

proc gplot data=&&Event&i ;
plot magnitude*duration / annotate = annocbema haxis = axis1 vaxis = axis2 html=tips1;
plot2 magnitude*incident /
haxis = axis1 vaxis = axis2 html=tips1/*noframe*/
autovref cvref=graydd
autohref chref=graydd
des="" name="&name" ;

run;

/* run;*/
slept= sleep(5);
%end;
%mend makeds;
%makeds;

Re: Dynamic auto refreshing charts

Jeema — Wed, 18 Jun 2014 08:27:37 GMT

Thanks for the prompt response.

We are using Base SAS to code the graph.

We are receiving the data from a meter during runtime, which would be the actual application.

As of now I have created a dataset after pulling the data from an excel and I need to populate each data(call it an Event) in the form of events in the graph which would happen in a span of time interval(lets say 10 seconds). So I believe I would require a Chart Dynamically generated by Data at runtime.

Is there any sample code that I can refer from to populate the change on the graph whenever an event occurs?

Dynamic auto refreshing charts

Jeema — Wed, 18 Jun 2014 08:00:28 GMT

How to create a chart which changes dynamically over time?

I have created a CBEMA curve graph which plots the data of the Power Quality events in Base SAS.

My requirement is to show the plot of scattered data (i.e the events) on the graph as they occur dynamically.

I want the graph to be refreshed automatically,and fetch the data row wise incrementing it in a particular small time frame gap (in seconds) thereby changing the graph dynamically over time.