Help using Base SAS procedures

How to get exact line for spinner headers?

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 86
Accepted Solution

How to get exact line for spinner headers?

 

 

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


Accepted Solutions
Highlighted
Solution
‎03-05-2018 02:51 AM
SAS Super FREQ
Posts: 9,365

Re: How to get exact line for spinner headers?

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;

View solution in original post


All Replies
Super User
Posts: 23,683

Re: How to get exact line for spinner headers?

Posted in reply to rajeshalwayswel

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

Super User
Posts: 10,766

Re: How to get exact line for spinner headers?

Posted in reply to rajeshalwayswel

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


Highlighted
Solution
‎03-05-2018 02:51 AM
SAS Super FREQ
Posts: 9,365

Re: How to get exact line for spinner headers?

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;
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 273 views
  • 5 likes
  • 4 in conversation