ODS Row height

[DLROW]

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.

[Reeza]

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

[ballardw]

---

@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.

[Cynthia_sas · Accepted solution]

Hi:

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

Cynthia

[DLROW]

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..

[Cynthia_sas]

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

[DLROW]

Thank you, Cynthia. It works.