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.
Don’t miss the livestream kicking off May 7. It’s free. It’s easy. And it’s the best seat in the house.
Join us virtually with our complimentary SAS Innovate Digital Pass. Watch live or on-demand in multiple languages, with translations available to help you get the most out of every session.
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.
Ready to level-up your skills? Choose your own adventure.