topic Re: Alligning Individual column headers in proc report with .rtf ODS in ODS and Base Reporting

Alligning Individual column headers in proc report with .rtf ODS

deleted_user — Thu, 30 Sep 2010 20:59:51 GMT

In proc report and rtf ODS, is there a way wherein I can allign each column header (Left, Right or center). I know the style (header) gives us the option to allign all the coulmn headers, but not individual coulmn headers.

I am using the following syntax for style (header) and defining columns. I would like to left allign only the column header _NAME_ .

style(header)={BOTTOMMARGIN = 0IN cellheight=.15in font_face= "Times New Roman" font_size=9pt background=_undef_ font_weight= medium textalign=left}

columns PAGEIT PLAN PARA OR VISIT1 P CL _NAME_ ("^R/RTF'\brdrb\brdrs\brdrw1'Placebo &VAR2 |" Placebo CPLAC) EMPTY ("^R/RTF'\brdrb\brdrs\brdrw1'SB-5090 &VAR3|" _60_mg C60MG) ;

Re: Alligning Individual column headers in proc report with .rtf ODS

Cynthia_sas — Thu, 30 Sep 2010 21:26:06 GMT

Hi:
STYLE(HEADER) in the PROC REPORT statement will impact ALL column headers on the report output. But you can also use STYLE(HEADER) on a DEFINE statement in order to impact just one variable's header.

In the code below, I set OUTPUTWIDTH=100% so you can see the impact of the different justification options. Note how I can justify the individual headers separately from the data cells. Also, note how HEIGHT and WEIGHT use the default header justification in the absence of any other instructions on a DEFINE statement.

cynthia
[pre]
ods listing close;
ods rtf file='c:\temp\align_hdr.rtf';

proc report data=sashelp.class nowd
style(header)={just=c}
style(report)={outputwidth=100%};
column name sex age height weight;
define name / 'The Name'
style(header)={just=r}
style(column)={just=c};
define sex / 'Gender'
style(header)={just=l}
style(column)={just=r};
define age / 'Age'
style(header)={just=r}
style(column)={just=l};
run;

ods rtf close;
[/pre]

Re: Alligning Individual column headers in proc report with .rtf ODS

deleted_user — Thu, 30 Sep 2010 22:20:49 GMT

Thanks for the help.