SAS Report Define Cell Alignment

Jyuen204 — Tue, 22 Aug 2023 19:47:49 GMT

I have this report formatting I am trying to set. In the excel it centers the CATEGORY horizontally but vertically it is aligned to the bottom of the grouping. I had read on some other threads theat CENTER should align it all but maybe i was reading it incorrectly.

Define CATEGORY / CENTER GROUP order=data "CATEGORY";

Re: SAS Report Define Cell Alignment

ballardw — Tue, 22 Aug 2023 20:10:58 GMT

The documentation for the CENTER option of a Define is pretty clear it only affects left-right justification:

headings

CENTER

centers the formatted values of the report item within the column width and center the column heading over the values.

You might get the vertical justification with this:

Define CATEGORY / CENTER GROUP order=data "CATEGORY" style=[vjust=center];

Might. Depends on ODS destination and possibly other options like the ods style in effect.

You should mention or better yet include ODS destination options. Last time I checked Report doesn't do a merged vertical cell as you show in the picture without considerable more than just a define like you show. Best is to include data as a working data step and your entire procedure code.

topic SAS Report Define Cell Alignment in SAS Procedures

SAS Report Define Cell Alignment

Re: SAS Report Define Cell Alignment

headings

CENTER