topic Re: spanned header align center and by variable groups align also center in ODS and Base Reporting

spanned header align center and by variable groups align also center

Ravikumarkummari — Tue, 15 Dec 2015 15:17:27 GMT

Hi Good evening all,

Need suggession in proc report. i used the below code for sashelp.class

ods tagsets.excelxp file="D:\New folder\sample.xls" style=minimal;
proc report data=sashelp.class nowd
STYLE(HEADER)={BACKGROUND=STEELBLUE FOREGROUND=WHITE FONTWEIGHT=BOLD FONT_FACE='CALIBRI' FONT_SIZE=10PT JUST=CENTER}
STYLE(REPORT)={BACKGROUND=WHITE FOREGROUND=BLACK BORDERCOLOR=WHITE FONT_FACE='CALIBRI' FONT_SIZE=10PT};
column sex ('Details' weight height);
define sex/ group;
define age/group;
define height /display;
define weight/display;
run;
ods tagsets.excelxp close;

the row header sex should be in center

by group variable of sex (F,M) that are also in center

the actual output we are getting and desired output i had attached in excel file.

please help me in this regard.

Thanks in advance.

Re: spanned header align center and by variable groups align also center

slchen — Tue, 15 Dec 2015 15:46:03 GMT

After define sex/group style={just=center};

style(column)={just=center} in proc report option.

Re: spanned header align center and by variable groups align also center

Ravikumarkummari — Tue, 15 Dec 2015 15:50:21 GMT

tried but not giving desired output

Re: spanned header align center and by variable groups align also center

Reeza — Tue, 15 Dec 2015 17:08:22 GMT

Use the SPANROWS option on the proc report statement. I don't believe there's a way to get the header merged into one cell using TAGSETS.

http://blogs.sas.com/content/sastraining/2011/02/28/whats-so-great-about-spanrows/

Re: spanned header align center and by variable groups align also center

Cynthia_sas — Tue, 15 Dec 2015 21:04:01 GMT

Hi:

It's not clear to me what you want. Just running your code, I can see that the header for SEX -is- centered -- you have to make the column wider to see the centering. But you only put JUST=CENTER on the STYLE(HEADER) override.

If you want to see the F and M also centered, then you need to do an override on the DEFINE for the SEX variable, as Reeza showed.

define sex / group style(column)={just=c};

If you want to "span" the row area then use the SPANROWS option.

cynthia

Re: spanned header align center and by variable groups align also center

Ravikumarkummari — Wed, 16 Dec 2015 02:53:22 GMT

ods rtf file="D:\New folder\sample123.rtf" style=overrides;
proc report data=sashelp.class nowd
STYLE(HEADER)={BACKGROUND=STEELBLUE FOREGROUND=WHITE FONTWEIGHT=BOLD FONT_FACE='CALIBRI' FONT_SIZE=10PT JUST=CENTER}
STYLE(REPORT)={BACKGROUND=WHITE FOREGROUND=BLACK BORDERCOLOR=WHITE FONT_FACE='CALIBRI' FONT_SIZE=10PT} SPANROWS;
column sex ('Details' weight height);
define sex / group style(column)= {just=center textalign=middle} ;
define age/group;
define height /display;
define weight/display;
run;
ods rtf close;

tried with ods rtf but desired output is not coming.

please suggest me.

Re: spanned header align center and by variable groups align also center

Cynthia_sas — Thu, 17 Dec 2015 00:05:24 GMT

Hi:
I do not believe that "textalign" is the correct style attribute. I have always used vjust=m or verticalalign=m. In the doc, it explains that just= and textalign= both apply to horizontal justification -- please see:
http://support.sas.com/documentation/cdl/en/odsug/67921/HTML/default/viewer.htm#p0xi2cygmfk0wkn1ei625zq5r488.htm#p0puqhkyzmrz5rn14lixs1ibsdm4 and also
http://support.sas.com/documentation/cdl/en/odsug/67921/HTML/default/viewer.htm#p0xi2cygmfk0wkn1ei625zq5r488.htm#n17x1nh0ypl1mzn1fn3gadhi52xw

cynthia