When I run a PROC REPORT in ODS tagsets.ExcelXP using aTitle statements, the Row Height of a Title statement that contains a date will get quite large. Here is my code: When the file is opened in Excel, the row height that has the Title3 statement is 198. How do I get this row to a more reasonable height? Note: If I remove the dates, the row height becomes normal. The dates can seemingly be in any format (mm/dd/yyyy, ddmmmyyyy, January 1, 2001). Help!! ODS tagsets.ExcelXP PATH=&g_ODS_Path FILE=&g_ODS_File STYLE=sasweb OPTIONS(frozen_headers = '6' autofit_height = 'yes' absolute_column_width = '35,21,8,14,14,14,14,14,14' center_horizontal = 'yes' merge_titles_footnotes= 'yes' orientation = 'landscape' print_header_margin = '.0' print_footer_margin = '.0' left_margin = '.5' right_margin = '.5' sheet_interval = 'none' sheet_name = "YTD &g_Year" embedded_footnotes = 'no' embedded_titles = 'Yes'); TITLE1; TITLE2 JUSTIFY=center ITALIC COLOR=gray FONT=Arial HEIGHT=12pt 'LSS Balancing Report'; TITLE3 JUSTIFY=center ITALIC COLOR=gray FONT=Arial HEIGHT=8pt "Activity Period: 1/1/2011 - 1/31/2011 Run Date: 8/2/2011 "; TITLE4 JUSTIFY=center ITALIC COLOR=gray FONT=Arial HEIGHT=6pt "Entered By: ALL - Entity: 8.ALL - HCP ID: 3. ALL_SYS - Report Type: 2. All_Consolidated - System Type: 3. ALL - Program Name: LSS_Balancing_Report.sas"; PROC report DATA=SummaryReport&g_Counter SPLIT='_' NOWD; COLUMN cat1 cat2 row_group_hdg GroupType Count Pmt_Posted Net_Cash_Fees Invoice_Generating_Fees NSF_Fees Adjustment_Entry_Fees Net_Transaction_Amount; DEFINE cat1 / order noprint; DEFINE cat2 / order noprint; DEFINE row_group_hdg / STYLE(column)=[FONT_FACE=Arial FONT_SIZE=1] 'Type'; DEFINE GroupType / STYLE(column)=[FONT_FACE=Arial FONT_SIZE=1] 'Pmt_Type'; DEFINE Count / STYLE(column)={FONT_FACE=Arial FONT_SIZE=1 tagattr='format:###,###,##0'} 'Count'; DEFINE Pmt_Posted / STYLE(column)={FONT_FACE=Arial FONT_SIZE=1 tagattr='format:$###,###,##0.00'} 'Pmt Posted'; DEFINE Net_Cash_Fees / STYLE(column)={FONT_FACE=Arial FONT_SIZE=1 tagattr='format:$###,###,##0.00'} 'Net Cash Fees'; DEFINE Invoice_Generating_Fees / STYLE(column)={FONT_FACE=Arial FONT_SIZE=1 tagattr='format:$###,###,##0.00'} 'Invoice Generating Fees'; DEFINE NSF_Fees / STYLE(column)={FONT_FACE=Arial FONT_SIZE=1 tagattr='format:$###,###,##0.00'} 'NSF Fees'; DEFINE Adjustment_Entry_Fees / STYLE(column)={FONT_FACE=Arial FONT_SIZE=1 tagattr='format:$###,###,##0.00'} 'Adjustment Entry Fees'; DEFINE Net_Transaction_Amount / STYLE(column)={FONT_FACE=Arial FONT_SIZE=1 tagattr='format:$###,###,##0.00'} 'Net Transaction Amount'; BREAK after cat2 / STYLE=[BACKGROUND=BLUE FOREGROUND=WHITE FONT_WEIGHT=BOLD FONT_SIZE=1] SUMMARIZE; run; ODS _all_ CLOSE;
... View more