topic Re: ods HTML Proc tabulate Column heading.. in ODS and Base Reporting

ods HTML Proc tabulate Column heading..

rkumar23 — Fri, 12 Sep 2014 04:13:16 GMT

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....

Re: ods HTML Proc tabulate Column heading..

Reeza — Fri, 12 Sep 2014 04:46:25 GMT

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

Re: ods HTML Proc tabulate Column heading..

Cynthia_sas — Fri, 12 Sep 2014 06:34:55 GMT

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;