topic Re: Alignment of column headers in SAS Procedures

Alignment of column headers

msg — Mon, 27 Apr 2009 10:43:55 GMT

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

Re: Alignment of column headers

andreas_lds — Tue, 28 Apr 2009 07:00:08 GMT

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

Re: Alignment of column headers

msg — Tue, 28 Apr 2009 09:20:33 GMT

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

Re: Alignment of column headers

Cynthia_sas — Tue, 28 Apr 2009 16:27:31 GMT

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

Re: Alignment of column headers

thummala — Wed, 15 Jun 2016 17:59:41 GMT

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.

Re: Alignment of column headers

Artem — Tue, 27 Mar 2018 11:34:37 GMT

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

Re: Alignment of column headers

DrAbhijeetSafai — Wed, 21 Feb 2024 10:04:41 GMT

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

- Dr. Abhijeet Safai