PROC REPORT - Add calculated row

[Charlotte37]

Hi,

I created a report with proc report.

Per day, I have parcels in and out. Some packages have deadlines to respect (priority 1 ...). By priority, I count the number of packets processed within the time limit and those that did not respect the time limit.

I am using the "break after" function to get the totals by week.

I would like to add a line (under the totals per week), in yellow on the photo, allowing to calculate the percentages by priority.

For example, 58,82% = 10 / (10+7)

Is-it possible with the proc report ?

Thanks,

[PeterClemmensen]

Yes. Post sample data to get a usable code answer 🙂

[Charlotte37]

An example :

DATA test;
LENGTH
Priorite $ 10
Date 8
semaine $20.
OK 8
KO 8;
FORMAT
Priorite $CHAR10.
Date DDMMYY10.
semaine $20.
OK 8.
KO 8.;
INFORMAT
Priorite $CHAR10.
Date DDMMYY10.
semaine $20.
OK 8.
KO 8.;
INPUT
Priorite : $CHAR10.
Date : DDMMYY10.
semaine : $20.
OK : 8.
KO : 8.;
CARDS;
P1 08/02/2021 6 1 0
P1 08/02/2021 6 1 0
P1 08/02/2021 6 0 1
P1 08/02/2021 6 1 0
P1 08/02/2021 6 0 1
P1 08/02/2021 6 1 0
P2 08/02/2021 6 0 1
P2 08/02/2021 6 1 0
P2 08/02/2021 6 1 0
P2 08/02/2021 6 1 0
P1 09/02/2021 6 1 0
P1 09/02/2021 6 1 0
P1 09/02/2021 6 0 1
P1 09/02/2021 6 0 1
P1 09/02/2021 6 1 0
P1 09/02/2021 6 1 0
P1 09/02/2021 6 0 1
P1 09/02/2021 6 1 0
P2 09/02/2021 6 0 1
P2 09/02/2021 6 1 0
P2 09/02/2021 6 1 0
P2 09/02/2021 6 0 1
P2 09/02/2021 6 1 0
P2 09/02/2021 6 1 0
P2 09/02/2021 6 1 0
P2 09/02/2021 6 0 1
P2 09/02/2021 6 1 0
P2 09/02/2021 6 1 0
P2 09/02/2021 6 1 0
P2 09/02/2021 6 1 0
;
run;

proc report data=test nowd;
column semaine date;
column priorite, (ok ko);

define date / group missing '';
define semaine / group missing 'Semaine';

define priorite / across missing "";
define ok / analysis SUM "OK";
define ko / analysis SUM "KO";

break after semaine / summarize;

compute after semaine;
if upcase(_break_) = 'SEMAINE' then do;
semaine="Semaine " ||semaine;
end;
endcomp;
run;

[ballardw]

Code currently using as well.

[Charlotte37]

Sorry, I don't understand 

[Charlotte37]

Hello,
I relaunch my subject. Is there a solution ?

[Cynthia_sas]

Hi: Look at some of the more complex break processing examples in this paper
https://support.sas.com/resources/papers/proceedings17/SAS0431-2017.pdf -- in particular, look at the compute block example #5 where extra break lines are put into the report. Your example would not need so many extra break lines, but I think you might need some extra helper variables. It's not clear to me exactly how your percent on the extra row is being calculated.
Cynthia