topic Re: proc report in SAS Programming

proc report

Ronein — Thu, 25 Jul 2019 09:40:54 GMT

Hello

The question is about proc report

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

/*Desired output by using proc report*/
a      30   30/200
b      70   70/200
c      100  100/200
Total  200  empty cel

Re: proc report

Ksharp — Thu, 25 Jul 2019 11:43:58 GMT

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

proc report data=tbl1 nowd;
column t y x z;
define t/group;
define y/group noprint;
define x/analysis sum;
define z/computed;
compute z/character length=20;
 z=catx('/',x.sum,y);
endcomp;
compute after ;
 t='total';z=' ';
endcomp;
rbreak after/summarize;
run;

Re: proc report

PaigeMiller — Thu, 25 Jul 2019 11:48:43 GMT

So, it helps when you provide examples that cover a range of situations. In your data, is Y always equal to 200, or can it take on other values?

Why does your output data set not contain D?