topic Re: Extra row height when using row_span and multiple text line in ODS PDF Report Writing in ODS and Base Reporting

Extra row height when using row_span and multiple text line in ODS PDF Report Writing

cxterm — Wed, 29 Aug 2018 15:13:47 GMT

I have a problem when using the sas report writing interface to create a pdf file. My table has a column need a long header, so I split it into two lines. however, there will be an extra space generated in the first row. Please look at the sample pdf and see the difference between the first row of two table header. the only difference of the code to create the two tables is the second table use a split header "Student*Name" in first column. how can I remove the extra space in second table? Thanks in advance!

below is my code of the example

options nodate nonumber;  
ods listing close;
ods pdf file="test.pdf" startpage=never;
title "Table Using Column and Row Spanning";
title2 "Two Tables, One for Females and One for Males";
proc format;
   value $gender
      F = "Females"
      M = "Males"
;
run;
proc sort data=sashelp.class out=class;
   by sex;
run;
data _null_;
	set class;
	where sex = 'F';
	by sex;
   	if _N_ = 1 then do;
		dcl odsout obj();
	end;
	if first.sex then do;
		obj.table_start();
	   		obj.head_start();
	      	obj.row_start();
	        	obj.format_cell(data: "Name", row_span: 2, vjust: "M");
	         	obj.format_cell(data: sex, column_span: 4, format: "$gender.");
	      	obj.row_end();
	      	obj.row_start();
	        	obj.format_cell(data: "Age");
	        	obj.format_cell(data: "Height");
	            obj.format_cell(data: "Weight");
	            obj.format_cell(data: "BMI");
	      	obj.row_end();
	   	obj.head_end();
	end;
	bmi = ( weight / ( height * height ) ) * 703;
   	obj.row_start();
    	obj.format_cell(data: name);
      	obj.format_cell(data: age);
      	obj.format_cell(data: height);
      	obj.format_cell(data: weight);
      	obj.format_cell(data: bmi, format: "8.2");
   	obj.row_end();
	if last.sex then do;
   		obj.table_end();
	end;
run;
data _null_;
	set class;
   	where sex='F';
	by sex;
	if _N_ = 1 then do;
		dcl odsout obj();
	end;

	if first.sex then do;
		obj.table_start();
	   		obj.head_start();
	      	obj.row_start();
	        	obj.format_cell(data: "Student*Name", split: '*', row_span: 2, vjust: "M");
	         	obj.format_cell(data: sex, column_span: 4, format: "$gender.");
	      	obj.row_end();
	      	obj.row_start();
	        	obj.format_cell(data: "Age");
	        	obj.format_cell(data: "Height");
	            obj.format_cell(data: "Weight");
	            obj.format_cell(data: "BMI");
	      	obj.row_end();
	   	obj.head_end();
	end;
	bmi = ( weight / ( height * height ) ) * 703;
   	obj.row_start();
    	obj.format_cell(data: name);
      	obj.format_cell(data: age);
      	obj.format_cell(data: height);
      	obj.format_cell(data: weight);
      	obj.format_cell(data: bmi, format: "8.2");
   	obj.row_end();
	if last.sex then do;
   		obj.table_end();
	end;
run;
ods pdf close;
ods listing;

Re: Extra row height when using row_span and multiple text line in ODS PDF Report Writing

ChrisNZ — Thu, 30 Aug 2018 03:34:29 GMT

I have no answer, but could this be due to the reader (Adobe's) being buggy?

If you replace

obj.format_cell(data: "Student*Name", split: '*', row_span: 2, vjust: "M");

with

obj.format_cell(data: "Student"||'0a'x||"Name", row_span: 2, vjust: "M");

obj.format_cell(data: "Student Name", row_span: 2, vjust: "M");

the result is the same.

So there is probably nothing in the PDF itself indicating the larger height.

Have you tried with other readers?

Re: Extra row height when using row_span and multiple text line in ODS PDF Report Writing

cxterm — Thu, 30 Aug 2018 04:11:13 GMT

Thanks for reply. I have tried your suggestion, but The same result. I also used several other viewer, still The same extra space there.

Re: Extra row height when using row_span and multiple text line in ODS PDF Report Writing

ChrisNZ — Thu, 30 Aug 2018 04:27:05 GMT

One for tech support I think.

In the mean time this seems to work somewhat:

obj.format_cell(data: "Student Name", row_span: 2, vjust: "M",overrides: "height=6mm");
obj.format_cell(data: sex, column_span: 4, format: "$gender.",overrides: "height=3mm");

Re: Extra row height when using row_span and multiple text line in ODS PDF Report Writing

cxterm — Thu, 30 Aug 2018 18:38:01 GMT

Thank you!

This method works. through I need manually adjust the row height each time.