topic Re: Question about how to keep the name of headers on the same line in Proc report? in SAS Programming

Question about how to keep the name of headers on the same line in Proc report?

Sikcion — Wed, 27 Dec 2023 00:51:36 GMT

Hi guys, I have a question about how to keep the name of headers on the same line in Proc report?

I am making a table in proc report statement and my code is :

proc report data=table12 nowindows headline headskip spacing = 10;
columns  AVISITN_1 Trt01a count mean_se;
define AVISITN_1/group order=data center width =20 " Test Day " style(column)={just=c};
define Trt01a /display center width=10 "Treatment" ;
define  count / display center width =14 "N";
define mean_se /display center  width = 40" Adjusted Mean(SE)";
title1 bold "Table11";
title2 bold  "Summary od Blood Glucose Level over time";
title3 bold "ITT Subjects";
  
compute after AVISITN_1;
line " ";
endcomp;
run;
ods pdf close;
And my output is:

My question is that i didn't use the split statement to divide the header and I want to keep "Test Day" and "Adjusted mean(SE)"headers in the same line.

Thanks!

Re: Question about how to keep the name of headers on the same line in Proc report?

Ksharp — Wed, 27 Dec 2023 01:38:27 GMT

Using Style:

style(header)={nobreakspace=on}

ods pdf file='c:\temp\temp.pdf';
proc report data=sashelp.class nowindows headline headskip spacing = 10  style(header)={nobreakspace=on} ;
columns   sex name age weight;
define sex/group order=data center width =20 " Test Day " style(column)={just=c}   ;
define name /display center width=10 "Treatment" ;
define  age / display center width =14 "N";
define weight /display center  width = 40" Adjusted Mean(SE)";
title1 bold "Table11";
title2 bold  "Summary od Blood Glucose Level over time";
title3 bold "ITT Subjects";
  
compute after sex;
line " ";
endcomp;
run;
ods pdf close;

Re: Question about how to keep the name of headers on the same line in Proc report?

angird1990 — Thu, 04 Jan 2024 07:29:14 GMT

what will the nobreakspace option do? Can anyone help me to understand?

Re: Question about how to keep the name of headers on the same line in Proc report?

Ksharp — Thu, 04 Jan 2024 07:47:46 GMT

https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/proc/p14xegao6xt0xnn1865r422tpytw.htm#n0q3uys7lzt7xgn1m6d43aqsctqpa

And I quoted:
To help prevent unexpected wrapping of long text strings when using PROC REPORT with the ODS RTF destination, set NOBREAKSPACE=OFF in a location that affects the LINE statement. The NOBREAKSPACE=OFF attribute must be set in the PROC REPORT code either on the LINE statement or on the PROC REPORT statement where style(lines) is specified.

Re: Question about how to keep the name of headers on the same line in Proc report?

Ksharp — Thu, 04 Jan 2024 07:50:14 GMT

https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/odsadvug/p1pt77toue3iyun0z4l9gth5as9f.htm

And I quoted:
NOBREAKSPACE=ON | OFF
specifies how to handle space characters in table cells.
ON
does not let SAS break a line at a space character.
OFF
lets SAS break a line at a space character if appropriate.
Valid in Markup family, Excel, printer family, and RTF destinations

Re: Question about how to keep the name of headers on the same line in Proc report?

angird1990 — Mon, 08 Jan 2024 05:25:30 GMT

Thank you @Ksharp. Understood now.