topic Re: PROC REPORT - Add calculated row in SAS Programming

PROC REPORT - Add calculated row

Charlotte37 — Wed, 10 Feb 2021 11:56:57 GMT

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,

Re: PROC REPORT - Add calculated row

PeterClemmensen — Wed, 10 Feb 2021 12:02:10 GMT

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

Re: PROC REPORT - Add calculated row

Charlotte37 — Wed, 10 Feb 2021 12:55:15 GMT

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;

Re: PROC REPORT - Add calculated row

ballardw — Wed, 10 Feb 2021 15:23:06 GMT

Code currently using as well.

Re: PROC REPORT - Add calculated row

Charlotte37 — Thu, 11 Feb 2021 11:40:45 GMT

Sorry, I don't understand

Re: PROC REPORT - Add calculated row

Charlotte37 — Fri, 12 Feb 2021 20:05:41 GMT

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

Re: PROC REPORT - Add calculated row

Cynthia_sas — Fri, 12 Feb 2021 20:55:12 GMT

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