topic Re: proc report---export to excel--row height in SAS Programming

proc report---export to excel--row height

Ronein — Fri, 09 May 2025 17:53:21 GMT

Hello

am running proc reports and export it into Excel file.

In one sheet I see that row height is too big (Right click in excel ---Row Height----I see the height is 29).

I want to modify the row height to 15.

I also see that DIF_FROM_PREV_MON looks bad when it is negative and can see only one bracket ) instead of two ()

Here is photo how how it looks like:

Here is a photo how I want it to look :

Here is the proc report code :

I export it using ODS EXCEL.

What change should I do in my proc report code to solve the 2 problems I mentioned:

1- reduce row height to 15

2- get two brackets in negative number (Now i see only one)

proc report data=S2 missing nowd;
column 
Ind
YYMM

("NR"
x	
w
z	
r
t)

("PCT"
P_w
P_z
P_r
P_t)

("DIF_FROM_PREV_MON"
P_Dif_w
P_Dif_z
P_Dif_r
P_Dif_t)
;
define IND /  DISPLAY;
define YYMM /  DISPLAY;

define x /  DISPLAY f=comma32.;
define w /  DISPLAY  f=comma32.;
define z /  DISPLAY  f=comma32.;
define r /  DISPLAY  f=comma32.; 
define t /  DISPLAY  f=comma32.;

define P_w /  DISPLAY;
define P_z /  DISPLAY;
define P_r /  DISPLAY;
define P_t /  DISPLAY;

define P_Dif_w / DISPLAY;
define P_Dif_z /  DISPLAY;
define P_Dif_r /  DISPLAY;
define P_Dif_t /  DISPLAY;

	compute IND;
		if IND = 0 then
			do;
				call define (_col_,"style", "style={background=lightgreen}");
			end;
		else if IND =1 then
			do;
				call define (_col_,"style", "style={background=lightred}");
			end;
	endcomp;
Run;

Re: proc report---export to excel--row height

Tom — Fri, 09 May 2025 20:06:30 GMT

Looks to me your issue is with the column width, not the row height.

In your first picture the PCT*W column is wrapping into two lines, which is why it needed to make the row taller.

Re: proc report---export to excel--row height

Ronein — Fri, 09 May 2025 22:01:56 GMT

Thanks.
Should I use ABSOLUTE_COLUMN_WIDTH ?

Re: proc report---export to excel--row height

Kathryn_SAS — Wed, 14 May 2025 12:06:18 GMT

You can try ABSOLUTE_COLUMN_WIDTH. The following will make all column widths 20. If you want to customize each column width, you would need to add more values separated by commas for each column.

ods excel file='test.xlsx'
 options(absolute_column_width='20');