How to left align column names in Proc Template?

angeliquec — Wed, 05 Nov 2014 08:52:44 GMT

Hi, I'd like to know how to left align column names in Proc Template or ODS Tagsets ExcelXP if possible.

In using proc template, I'd like to avoid hard coding the column names in the Define statement.

Thank you!

Re: How to left align column names in Proc Template?

RW9 — Wed, 05 Nov 2014 09:50:37 GMT

Looking at the styles.default style template, the option would be textalign=left/center/right;

If you are in SAS (not EG VA etc.) you can see templates by right clicking on Results in the Results tab and choosing Templates. Simplest way is to find a style which is near to your needs then inherit from that and change the parts you need. So to change some colors:

proc template;

define style Styles.Mygraph1;

parent = Styles.statistical;

style ColorStyles /

'c3' = red

'c2' = blue

'c1' = orange;

end;

run;

As for ExcelXP, well that would depend on the style you choose to apply. I personally prefer to put the information in the proc report however as its clearer for my purposes:

proc report ... style(column)=[just=l] ...; /* Applies to whole table */

define col / "A Column" style(column)=[just=r]; /* Applies to the column */

compute ...;

call style...; - /* can apply to any item */

topic Re: How to left align column names in Proc Template? in SAS Procedures

How to left align column names in Proc Template?

Re: How to left align column names in Proc Template?