The SAS Output Delivery System and reporting techniques

ods HTML Proc tabulate Column heading..

Reply
Frequent Contributor
Posts: 78

ods HTML Proc tabulate Column heading..

Looking for some suggestion and way of achieving below objective :

I have some reports which is being produced using the Proc TABULATE and Columns have HEADER which are variables now what Since i can not have more eloborative variable description I am looking some way so that when a cursor is moved to the Column heading either it provide you option to click on that header and that open another small window which provide more eloborative description of that column or do not open another window but when cursor is moved to the header it give you quite more description of the column....not sure if this can be acheived however thought to throw this question...

Thanks for throwing some ideas here....

Grand Advisor
Posts: 17,332

Re: ods HTML Proc tabulate Column heading..

Look at the flyover option., but not sure it can do what you fully want.

SAS Super FREQ
Posts: 8,719

Re: ods HTML Proc tabulate Column heading..


Hi: What do you mean by "more elaborate variable description"? You can have a very long label. Please see the results of the attached program. Otherwise, flyover is your only other option.

Cynthia

%let elab1 = %str(Twas brillig and the slithy toves did gyre and gimble in the wabe.);

%let elab2 = %str(All mimsy were the borogroves and the mome raths outgrabe.);

%let elab3 = %str(Beware the Jabberwock, my son! The jaws that bite, the claws that snatch.);

%let flyov = %str(This is some flyover text);

     

ods html file='c:\temp\elaborate.html';

  

proc tabulate data=sashelp.class;

title 'Examples of Elaborate Text Labels for column headers';

  class age sex;

  classlev age / style={width=1.5in};

  var height;

  var weight / style={flyover="&flyov"};

  table age all,

        sex="&elab2"*(height="&elab3" weight)*(min mean max) /

        box="&elab1";

run;

  

ods html close;

Attachment
Ask a Question
Discussion stats
  • 2 replies
  • 356 views
  • 0 likes
  • 3 in conversation