proc report

Ronein — Thu, 25 Jul 2019 08:46:32 GMT

Hello

In this proc report example I want that in last row under Y column will be empty cell (and not 150 value)

What is the way to do it please?

I want also that in last row under "t" column will written "All" and not empty cell

data tbl1;
input ID t $ X Y;
cards;
1 a 10 150
2 a 20 150
3 a 30 150
4 b 40 150
5 b 50 150
;
run;

proc report data=tbl1;
columns  t x y ;
define t/group;
define x/sum;
define y/max;

rbreak after /summarize ol ul;

run;

Re: proc report

Kurt_Bremser — Thu, 25 Jul 2019 09:04:39 GMT

Then why do you tell proc report to calculate a max, when you don't want it?

Try this:

proc report data=tbl1;
columns  t x y ;
define t/group;
define x/sum;
define y/display;

rbreak after /summarize ol ul;
compute after;
  t = 'Total';
endcomp;

run;

Result:

t                 X          Y
a                10        150
                 20        150
                 30        150
b                40        150
                 50        150
--------  ---------           
Total           150           
--------  ---------

topic Re: proc report in SAS Programming

proc report

Re: proc report