topic how can i sort the computed Total_count variable as descending order in proc report in SAS Programming

how can i sort the computed Total_count variable as descending order in proc report

anil2 — Fri, 20 Apr 2018 07:58:34 GMT

PROC REPORT DATA=expo.OPEN_TICKET_SUMMARY_SOURCE1 out=expo.summary_table_result 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 UserName (category,status) Total_count ;
DEFINE UserName / GROUP style=[background=#BBDEFB foreground=black font_weight=bold borderleftwidth=2 borderrightwidth=2] ;
DEFINE CATEGORY / ACROSS style =[borderleftwidth=1 borderrightwidth=1];
DEFINE STATUS / ACROSS style =[borderleftwidth=1 borderrightwidth=1 ];
define total_count / computed style=[font_weight=bold foreground=black ] ;
rbreak after / summarize;
compute total_count;
Total_count=sum(input(_c2_,best32.),
input(_c3_,best32.),
input(_c4_,best32.),
input(_c5_,best32.),
input(_c6_,best32.),
input(_c7_,best32.),
input(_c8_,best32.),
input(_c9_,best32.),
input(_c10_,best32.)
);

IF total_count ^= ''
THEN CALL DEFINE(_COL_, "style", "STYLE=[BACKGROUND=white ]");
endcomp;

RUN;

Re: how can i sort the computed Total_count variable as descending order in proc report

RW9 — Fri, 20 Apr 2018 08:20:56 GMT

Why not summarise your data in a a datastep before the proce report using a procedure designed for such a task - means/summary - then use a simple proc report to print the data out. You have full control over the data then.

Re: how can i sort the computed Total_count variable as descending order in proc report

ballardw — Fri, 20 Apr 2018 14:34:31 GMT

As I understand proc report you can only modify the order of appearance of variables that are Group, Order or Across, not computed.

So to get the desired order I think you'll want to go with @RW9's suggestion of summarizing the data prior to building the report.

Re: how can i sort the computed Total_count variable as descending order in proc report

anil2 — Mon, 11 Jun 2018 15:28:25 GMT

Thanks,
@ballardw i have solved above issue by using datafmt option