The following code produces titles that wrap and a merge cells. Can I prevent both?
35 ods excel options (Sheet_name="Table" sheet_interval='NOW' row_heights='40,0'
36 ABSOLUTE_COLUMN_WIDTH = '10,30,30' flow="header,data");
38 proc report data=Daily3;
39 col Date Tot_Avg Adult_Cov;
40 define Date / display 'Date';
41 define Tot_Avg / display format=comma8. 'Number of patients hospitalized with confirmed COVID-19 (7 day average)';
42 define Adult_Cov / display format=comma8. 'Number of hospitals reporting on adult patients with confirmed COVID';
43 /*AP implies data should start on August 1, 2020*/
44 where Date ge mdy(8,1,2020);
45 Title 'Analysis of COVID-19 Hospitalizations Data';
46 Title2 'Through May 2023';
47 Title3 "Median number of patients hospitalized with confirmed COVID-19 (7 day average):&median1 (thru &max_date1)";
48 Title4 "Median number of patients hospitalized with confirmed COVID-19 (7 day average):&median2 (thru &max_date2)";
49 Title5 "Median number of patients hospitalized with confirmed COVID-19 (7 day average):&median3 (thru &max_date3)";
Are you showing all of your code? I don't see any embedded_titles suboption, so I'm not sure where your titles are wrapping or not wrapping.
Perhaps you are trying to over-control the cellwidths and row heights. When I simplify all the suboptions and include the embedded_titles suboption, I am not seeing any wrapping, as shown below:
As you can tell, I used SASHELP.PRDSALE for my example because it has a date variable that I can use for the first column. I made fake values for the macro variables in the TITLE statements.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.