Hey Cynthia, sorry, Every time I post my complete code the end is chopped off...
ods tagsets.ExcelXP path="&out_path" file="&out_file"
options(absolute_column_width="25,5,7,5,8,3,6,3,5,6,5,6,5,6,5"
embedded_titles='yes'
sheet_interval='bygroup'
sheet_label='none'
sheet_name='none'
suppress_bylines='yes'
zoom='85'
orientation='landscape'
fittopage='yes'
PROC REPORT nowd DATA=&in_dataset MISSING nowindows SPLIT='*' HEADLINE contents = ''
style(header)={font_weight=bold font_face="Franklin Gothic Medium" background=CXDBDEE1 foreground=black}
style(column)={background=white font_face="Franklin Gothic Medium"}
;
by attorney;
column count attorney name product status account_nbr city state pacman_claim_number
policy_year reserve
('Next*Upcoming Tickler' date_of_tickler_max userid)
('Last*Reserve Review*Diary' date_of_res_rev_max days_since_last_res_rev ) days_since_last_res_rev_color
('Last*Diary Record' date_of_diary_max days_since_last_diary) days_since_last_diary_color n ;
define count / order noprint;
define attorney / order noprint;
define product / 'Product';
define status / 'Status';
define account_nbr / 'Account';
define name / 'Account Name';
define city / 'City';
define state / 'State';
define pacman_claim_number / 'Claim Number';
define policy_year / 'Pol*Year';
define date_of_tickler_max / 'Date' format=mmddyy10.;
define userid / 'Created*By' ;
define reserve / 'Reserve' format=dollar12.;
define date_of_res_rev_max / 'Date' format=mmddyy10.;
define days_since_last_res_rev / '# Days' format=comma6.;
define date_of_diary_max / 'Date' format=mmddyy10.;
define days_since_last_diary / '# Days' format=comma6.;
define n / noprint;
define days_since_last_res_rev_color / computed noprint;
define days_since_last_diary_color / computed noprint;
break before count / contents = "" page;
compute days_since_last_res_rev_color;
.....
endcomp;
compute days_since_last_diary_color;
.....
endcomp;
compute after attorney/style={background=RED};
line @1 'Total # of Claims: ' n comma6.;
endcomp;
title color = CX00447C font="Franklin Gothic Medium" h=14pt
"All Open Claims Detail by Attorney As Of: " &asofdate #byval(attorney);
run;
... View more