Another possible approach requires restructuring your data. You have apparently two similar measures at different time frames:
unclosed_14_plus_num
unclosed_14_plus_amt
transcription_14_plus_num
transcription_14_plus_amt
unsigned_esig_14_plus_num
unsigned_esig_14_plus_amt
hospital_14_plus_num
hospital_14_plus_amt
cosigns_14_plus_num
cosigns_14_plus_amt
total_14_plus_num
total_14_plus_amt
unclosed_8_plus_num
unclosed_8_plus_amt
transcription_8_plus_num
transcription_8_plus_amt
unsigned_esig_8_plus_num
unsigned_esig_8_plus_amt
hospital_8_plus_num
hospital_8_plus_amt
cosigns_8_plus_num
cosigns_8_plus_amt
total_8_plus_num
I would be tempted to create a variable with the "14_plus" or "8_plus" as an additional and then have the variables reduced to
unclosed_num
unclosed_amt
transcription_num
transcription_amt
unsigned_esig_num
unsigned_esig_amt
hospital_num
hospital_amt
cosigns_num
cosigns_amt
total_num
total_amt
And using that time frame variable a grouping variable to control things:
Something along the lines of :
proc report data=tmp3 nowindows nowd spanrows
style(report)={font_face=times font_size=1}
style(column)={just=center font_face=times background=white foreground=black
font_size=1 cellwidth=.6in}
style(header)={just=center font_face=times cellheight=.7in font_size=1
foreground=black cellwidth=.6in background=white};
column timeframe scheduling_department
report_dt
unclosed_num
unclosed_amt
transcription_num
transcription_amt
unsigned_esig_num
unsigned_esig_amt
hospital_num
hospital_amt
cosigns_num
cosigns_amt
total_num
total_amt
;
define timeframe /group;
define scheduling_department / group
style(header)={vjust=middle}
style(column)={vjust=middle};
define report_dt / order order=internal format=mmddyy10.
style(header)={vjust=middle}
style(column)={vjust=middle};
break after scheduling_department / summarize;
compute after scheduling_department; line ' '; endcomp ;
run;
Or possibly as an Across variable
proc report data=tmp3 nowindows nowd spanrows
style(report)={font_face=times font_size=1}
style(column)={just=center font_face=times background=white foreground=black
font_size=1 cellwidth=.6in}
style(header)={just=center font_face=times cellheight=.7in font_size=1
foreground=black cellwidth=.6in background=white};
column scheduling_department
report_dt
timeframe,(
unclosed_num
unclosed_amt
transcription_num
transcription_amt
unsigned_esig_num
unsigned_esig_amt
hospital_num
hospital_amt
cosigns_num
cosigns_amt
total_num
total_amt )
;
define timeframe /across;
define scheduling_department / group
style(header)={vjust=middle}
style(column)={vjust=middle};
define report_dt / order order=internal format=mmddyy10.
style(header)={vjust=middle}
style(column)={vjust=middle};
break after scheduling_department / summarize;
compute after scheduling_department; line ' '; endcomp ;
run;
... View more
