How to right justify column name?

Belle — Thu, 27 Sep 2012 05:00:45 GMT

Hello,

I am trying to produce a report by using ODS TAGSETS.EXCELXP.

How can I make all the column names and values right justify?

In my result, I used label name as output column name. Unfortunately, I did not get all the column names and values right justify. Could you please let me know where I did wrong.

Here is the result that I got:

Here is the result that I want:

Here are the part of data from dataset FIN I use as input data:

Obs YYMM _NAME_ _LABEL_ MISSING_ NON_MISSING_

1 200104 COUNT Frequency Count 18 53

2 200105 COUNT Frequency Count 67 .

Below are part of my program:

DATA FINAL (DROP=_NAME_ _LABEL_);

SET FIN;

IF MISSING = . THEN MISSING = 0;

IF NON_MISSING = . THEN NON_MISSING = 0;

PCT_MISS=MISSING/(MISSING+NON_MISSING);

FORMAT PCT_MISS PERCENT9.1 ;

LABEL justify=right MISSING = " Missing"

justify=right NON_MISSING = "Not Missing"

justify=right PCT_MISS = "PCT Missing";

RUN;

ODS TAGSETS.EXCELXP

OPTIONS(SHEET_NAME ="sheet name"

FROZEN_HEADERS='1'

ROW_REPEAT ='1'

WIDTH_FUDGE ='0.6'

ABSOLUTE_COLUMN_WIDTH='8,12.5,12.5,12.5'

AUTOFILTER ='1'

ORIENTATION ='LANDSCAPE'

FITTOPAGE ='YES'

);

proc print data = FINAL noobs label;

run;

...

Thank you so much for the help in advance.

Belle

topic How to right justify column name? in SAS Procedures

How to right justify column name?