Pyrite | Level 9

## insert a sum row in PROC TABULATE

I want to amend my code so that there is a row after each school that sums the N count for grades 6, 7 and 8 and calculates the percent before going to the next school.  Below is a partial output and my code.

proc tabulate data=one;

by schlevel;

all='TOTAL'*(n*f=6.0)/rts=25 misstext='0' printmiss;

run;

 PERFORMANCE LEVEL TOTAL Does Not Meet Approaches Meets Exceeds N PCT N PCT N PCT N PCT N SCHOOL GRADE 55 22 105 42 71 28 22 9 253 School A 06 07 56 22 91 36 65 25 44 17 256 08 56 22 79 31 82 32 41 16 258 School B 06 2 7 16 59 9 33 0 0 27 07 10 23 23 53 9 21 1 2 43 08 8 24 15 44 9 26 2 6 34
1 ACCEPTED SOLUTION

Accepted Solutions
Super User

## Re: insert a sum row in PROC TABULATE

This should do:

``````proc tabulate data=one;
by schlevel;
ela='PERFORMANCE LEVEL'*(n*f=6.0 pctn<ela>='PCT'*f=6.0)
all='TOTAL'*(n*f=6.0)
/rts=25 misstext='0' printmiss
;
run;``````

Note that schools with only one grade will basically have a duplicate row for that single grade.

2 REPLIES 2
Super User

## Re: insert a sum row in PROC TABULATE

This should do:

``````proc tabulate data=one;
by schlevel;
ela='PERFORMANCE LEVEL'*(n*f=6.0 pctn<ela>='PCT'*f=6.0)
all='TOTAL'*(n*f=6.0)
/rts=25 misstext='0' printmiss
;
run;``````

Note that schools with only one grade will basically have a duplicate row for that single grade.

Pyrite | Level 9

## Re: insert a sum row in PROC TABULATE

Beautiful.  Thanks!

Discussion stats
• 2 replies
• 7807 views
• 0 likes
• 2 in conversation