topic Re: ODS Row height in ODS and Base Reporting

ODS Row height

DLROW — Tue, 11 Dec 2018 18:22:37 GMT

Hi, I want to reduce the below row height. I used Absolute Row height and Absolute column width but the width is increasing but it is not working the way that I want.

Customer
Rating
of
Products

Customer
Rating
of
Online
Products

Customer
Feeback
Response

I want this to be like,

Customer Rating
of Products

Customer Rating
of Online Products

Customer Feeback
Response

Plese let me know what should I add. Thanks.

Re: ODS Row height

Reeza — Tue, 11 Dec 2018 18:29:05 GMT

Are you using PROC REPORT? Have you tried specifying a SPLITCHAR? Or explicitly setting the widths.

Re: ODS Row height

ballardw — Tue, 11 Dec 2018 18:55:28 GMT

@DLROW wrote:

Hi, I want to reduce the below row height. I used Absolute Row height and Absolute column width but the width is increasing but it is not working the way that I want.

Customer
Rating
of
Products Customer
Rating
of
Online
Products Customer
Feeback
Response

I want this to be like,

Customer Rating
of Products Customer Rating
of Online Products Customer Feeback
Response

Plese let me know what should I add. Thanks.

Hard to know what to add without knowing what you currently have. Please post the code used to generate your output in a code box opened with the forum's {I} icon.

Re: ODS Row height

Cynthia_sas — Tue, 11 Dec 2018 19:31:48 GMT

Hi:

Here's what you'd do in PROC REPORT:

Cynthia

Re: ODS Row height

DLROW — Wed, 12 Dec 2018 16:37:35 GMT

Thanks Cynthia, it worked.

Below is the code that I used before,

split='*'

define customer rating of products / 'customer rating * of products' width=20

Using Style(Column) ={width-1.5in} worked. Thanks!

Now, the columns next to it are at the bottom of the cell, I wanted it to be at the top. Attached the screen shot for your referrence..

Re: ODS Row height

Cynthia_sas — Wed, 12 Dec 2018 19:27:22 GMT

Hi:
You'll need to add a STYLE override for the HEADER so that vertical alignment is TOP. So like this:
PROC REPORT data= ... split='/'
style(header)={vjust=t}
style(column)={ ... .. };
...more code ...
run;

Cynthia

Re: ODS Row height

DLROW — Thu, 13 Dec 2018 12:38:56 GMT

Thank you, Cynthia. It works.