Alignment of column headers

[msg]

This is regarding the alignment of column headers in the proc report.

Is there any option to center align column header and left align the column value?

The define statement, when given with "left" option also left aligns its column header to left.

Thanks

[andreas_lds]

Maybe the paper "Beyond the Basics: Advanced PROC REPORT Tips and Tricks" has the answer to your question. It can be found at http://support.sas.com/rnd/papers/sgf07/sgf2007-report.pdf

[msg]

Thanks andreas_Ids.

But this paper doesn't contain any info/options about aligning the column header to left/center/right.

For Ex.

proc report data=sample_data nowd;
column ('Employee ID' id) ('Employee Name' name);
define id / display right;
display name / display left;
run;

This code will make, not only the column values to right & left, but also the headers..... But, i want the header to be unaffected.

Thanks

[Cynthia_sas]

Hi:
For ODS destinations that support style (NOT the LISTING destination), you can specify separate alignment:
[pre]
define name / display
style(header)={just=c}
style(column)={just=l};
[/pre]

You'd have to try this in your ODS destinations of interest. For ODS RTF, PDF and HTML, the STYLE= overrides should work. For destinations like ODS CSV and others, the alignment overrides might not work. The STYLE= overrides are will NOT work for LISTING output (what you see in the Results Window).

cynthia

[thummala]

Hi,

Is there an option that I can use to allign the column header to left in the .txt file that is generated using proc report.

for example:

proc report data=abc  options;

column var1 ("left text"  var2 var3 var4 var5) var6;

[/pre]

I want the output to look like

                  left text________________

var1           var2     var3     var4    var5      var6

Thank You.

[Artem]

column var1 ("(*ESC*)S={just = left}left text(*ESC*)S={}"  var2 var3 var4 var5) var6;

[DrAbhijeetSafai]

These things are known most of the times, but ready reference here is really helpful! Thank you.

- Dr. Abhijeet Safai