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");
37
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)";
50 run;
Hi:
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.
Cynthia
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.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.