topic Re: How to get exact line for spinner headers? in SAS Procedures

How to get exact line for spinner headers?

rajeshalwayswel — Thu, 01 Mar 2018 19:36:31 GMT

proc report data=sashelp.class nowindows split='~';

column name 'Result~_' age sex weight height;

run;

If I give sigle '_' I'm getting small line above the variables I need a line for all spin header variables exact .

Is there any logic for it?

For example for spinner header variables there 10 variables and I want a line above all the ten variables how many '_' should i need to give?

Result

__________________

Required Output: name age sex height weight

Re: How to get exact line for spinner headers?

Reeza — Thu, 01 Mar 2018 20:20:52 GMT

Have you tried modifying the style instead?

What output are you using?

@rajeshalwayswel wrote:

Is there any logic for it?

Of course - but it depends on what you're trying to acomplish which isn't that clear.

If you search some papers on PROC REPORT you'll find examples

Re: How to get exact line for spinner headers?

Ksharp — Fri, 02 Mar 2018 12:29:01 GMT


ods escapechar="^";
proc report...;
  columns x ("^R'\brdrb\brdrs\brdrw15 'Powers" y z) ;

Re: How to get exact line for spinner headers?

Cynthia_sas — Fri, 02 Mar 2018 19:24:46 GMT

Hi:

If you use STYLE=JOURNAL with ODS RTF, this technique also works.

cynthia

ods rtf file='c:\temp\span_underline.rtf' style=journal;
ods escapechar='^';
proc report data=sashelp.class;
  column name 
     ('^{style[borderbottomcolor=black borderbottomwidth=2px]Result}' age height weight);
run;
ods rtf close;