ODS PDF FILE="E:\RF_CCDS\overall_Helpdesk_Tickets.pdf" startpage=no;
title "Oveall Pending Summary Report";
title1 "Zone Wise Pending Summary Report";
PROC REPORT DATA=pending_summary_ZoneWise out=summary_table_zonewise LIST
/*style=[cellwidth=.1 in rules=group frame=void] */
style(header)=[background= #BBDEFB foreground=black]
style(summary)=[background=white foreground=black font_weight=bold];
COLUMN Zone Product_ '<=2 days'n '3-5 DAYS'N '6-7 DAYS'N '8-10 DAYS'N '>10 DAYS'N 'Total App'n ;
DEFINE Zone / display ;
DEFINE Product_ / display ;
define '<=2 days'n /display analysis sum style(header)={background=green foreground=black};
define '3-5 DAYS'N /display analysis sum style(header)={background=green foreground=black} ;
define '6-7 DAYS'N /display analysis sum style(header)={background=yellow foreground=black};
define '8-10 DAYS'N /display analysis sum style(header)={background=red foreground=black};
define '>10 DAYS'N /display analysis sum style(header)={background=red foreground=black} ;
define 'Total App'n /display analysis sum style=[font_weight=bold foreground=black ] ;
RUN;
ods pdf close;
Have a look at the documentation of proc report ... you need a break statement ... http://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/viewer.htm#a002473623.htm
I think you could change the definition of Zone to ORDER, and then have a line like "Break after zone/summarize"
title1 "Zone Wise Pending Summary Report";
PROC REPORT DATA=pending_summary_ZoneWise out=summary_table_zonewise LIST
/*style=[cellwidth=.1 in rules=group frame=void] */
style(header)=[background= #BBDEFB foreground=black]
style(summary)=[background=white foreground=black font_weight=bold];
COLUMN Zone Product_ '<=2 days'n '3-5 DAYS'N '6-7 DAYS'N '8-10 DAYS'N '>10 DAYS'N 'Total App'n ;
define Zone /display group ;
rbreak after / summarize;
DEFINE Product_ / display ;
define '<=2 days'n / analysis sum style(header)={background=green foreground=black};
define '3-5 DAYS'N / analysis sum style(header)={background=green foreground=black} ;
define '6-7 DAYS'N / analysis sum style(header)={background=yellow foreground=black};
define '8-10 DAYS'N / analysis sum style(header)={background=red foreground=black};
define '>10 DAYS'N / analysis sum style(header)={background=red foreground=black} ;
define 'Total App'n / analysis sum style=[font_weight=bold foreground=black ] ;
RUN;
Have a look at the documentation of proc report ... you need a break statement ... http://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/viewer.htm#a002473623.htm
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.