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;
