I'm trying to suppress the frequency count header without leaving a blank row and I want lines separating the error types from the department names and totals. Below is the current header, future header and my code. Thanks for the help. This is my first proc report and this is the last thing I'm stuck on. Charlotte Current Header: Error Types Error Free Attending Event Type Provider RTT Process Provider Unknown Provider For Consult Department Name Total Appointments Future Header: Error Types Department Name Error Free Attending Event Type Provider RTT Process Provider Unknown Provider For Consult Total Appointments Code: report data=qa10 nowd style(report)={rules=groups font_size=10} style(header)=header{background=white rules=groups}; column dept_name error_type,count total_appt; define dept_name / group width=25 "Department Name" ; /*format for alternating row highlight*/ compute dept_name; 1; if (mod(count,2)) then do; CALL DEFINE(_ROW_, "STYLE", "STYLE=[BACKGROUND=#DCDCDC]"); end; endcomp; define error_type /across format=etypfmtb. "Error Types" order=internal ;/*orders the error types as required*/ define count /analysis ""; /*must be analysis variable so it will summarize at bottom*/ define total_appt / computed "Total Appointments" ; compute total_appt ; total_appt=sum(_C2_, _C3_, _C4_, _C5_, _C6_, _C7_); endcomp; after / summarize skip dol dul; compute after; dept_name="Total:"; endcomp; run; quit;
... View more