09-27-2012 01:00 AM
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_);
IF MISSING = . THEN MISSING = 0;
IF NON_MISSING = . THEN NON_MISSING = 0;
FORMAT PCT_MISS PERCENT9.1 ;
LABEL justify=right MISSING = " Missing"
justify=right NON_MISSING = "Not Missing"
justify=right PCT_MISS = "PCT Missing";
OPTIONS(SHEET_NAME ="sheet name"
proc print data = FINAL noobs label;
Thank you so much for the help in advance.