Hello, I'm a novice so apologies in advance - I have programmed a table, and now want to add two new rows - sum rows A and B into a new row, A+B; sum rows C and D into a new row, C+D. Is there a simple way to do this? Enrollment Phase 1 Phase 1 Phase 2 Phase 2 Site Name Enrolled # % # % A 8 8 100 8 100 B 8 8 100 8 100 C 3 3 100 3 100 D 8 8 100 8 100 A+B C+D Total 27 27 100 27 100 proc report data = Samples; column ('Enrollment' sitename Enrolled ('Sample Collection' ('Phase 1' NP1 PctNP1) ('Phase 2' NP2 PctNP2))); define sitename / group center format = sites.; define Enrolled / analysis '#'; define NP1 / analysis '#'; define PctNP1 / computed '%'; define NP2 / analysis '#'; define PctNP2 / computed '%'; define NP2 / analysis '#'; compute PctNP1; PctNP1 = round((_c3_/_c2_)*100,0.1); endcomp; compute PctNP2; PctNP2 = round((_c5_/_c2_)*100,0.1); endcomp; compute sitename; if _break_ ='_RBREAK_' then call define('sitename','style','style=[pretext="Total"]'); endcomp; rbreak after / summarize ul ol; run; ods startpage = now;
... View more