topic Re: how can i get column sum group by zone in proc report sas in SAS Programming

how can i get column sum group by zone in proc report sas

anil2 — Mon, 11 Jun 2018 15:36:22 GMT

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;

Re: how can i get column sum group by zone in proc report sas

s_lassen — Tue, 12 Jun 2018 10:05:19 GMT

I think you could change the definition of Zone to ORDER, and then have a line like "Break after zone/summarize"

Re: how can i get column sum group by zone in proc report sas

anil2 — Tue, 19 Jun 2018 11:24:53 GMT

@s_lassen thanks for the solution its working i am getting my excepted column sum output for all zone .
and can you help to calculate Zonewise column sum.

Re: how can i get column sum group by zone in proc report sas

anil2 — Tue, 19 Jun 2018 11:39:14 GMT

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;

Re: how can i get column sum group by zone in proc report sas

andreas_lds — Tue, 19 Jun 2018 11:49:07 GMT

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