The SAS Output Delivery System and reporting techniques

tagsets.mvshtml - Drill down/Append every day data

Reply
Frequent Contributor
Posts: 78

tagsets.mvshtml - Drill down/Append every day data

Anybody has any idea how we can create a DRILL Down ODS HTML reports and also append EVERY DAY new report in the Existing FRAME ?  I have requirement where every day need to process the RAW data and then the reports which get produce need to be appended in the Existing Frame......Any ideas would be greatly appreciated....

ods trace on;                                          

ods noproctitle;                                       

ods listing close ;                                    

                                                       

ods tagsets.mvshtml                                    

    path="xxxxxxx.output.html"                         

    gpath="xxxxx.output.html"                        

    Base="//xxxxx.xxxxx.com/MVSDS/"         

    body="cpu"                                         

    contents="concpu"                                  

    frame="frmcpu"                                     

    (title="cpu report")                               

    anchor='anchor'                                    

    record_seperator=none                              

    style=barrettsblue                                 

    newfile=output  ;                                  

ods proclabel  "vts cpu utilization report";          

proc tabulate data=bvir30 contents=' ' ;                             

by date;                                                             

                                                                     

title ' vts cpu utilization report' ;                               

keylabel n= ' ' sum=' ' mean=' ' pctn=' ' pctsum=' ';               

class date time cluster dlibseqn glibseqn machserl                  

       / style={just=center};                                        

var avgcpuse                                                        

      /  style={background=pink};                                    

table date*time *{style={background=white}},                        

       (dlibseqn*machserl*cluster)                                   

       *avgcpuse*{style={background=difffmt.}}*f=percent10.*sum=' '/ 

        nocontinued condense indent=1 rts=20                         

        box = glibseqn                                               

        style={bordercolor=blue} ;                                   

run;                                                                 

ods tagsets.mvshtml close;                                          

Esteemed Advisor
Esteemed Advisor
Posts: 7,241

Re: tagsets.mvshtml - Drill down/Append every day data

Not having used this tagset myself I would suggest that updating an existing output would not be straightforward.  This is covered in another post, that one regarding ExcelXP.  Basically these are outputs, not really intended to updated in part, just generated as one whole.  So you could run your SAS program to generate the outputs each day, i.e. a new file.

I would imagine that you would need some kind of scripting (VB/JavaScript) in your HTML file which would read new data and generate the output with the HTML (i.e. nothing to do with SAS).

So to clarify, as far as I am aware there is no "automatic refresh of outputs based on new input data".  The outputs are fixed once generated and would need to be re-run to show any new items.  You could however write some script and embed into your HTML to load data and produce a graph from there, however this is not within the bounds of SAS.

Ask a Question
Discussion stats
  • 1 reply
  • 298 views
  • 0 likes
  • 2 in conversation