Sum values by classes and format the output

[NewUsrStat]

Thank you Tom, but still "0" remains out. I also need to count (or sum) when all cat* have "0" to get 125, 33, 44. This output seems to disappear but I need to show numbers when no one has "1" in DB1

[Tom]

---

@NewUsrStat wrote:
Thank you Tom, but still "0" remains out. I also need to count (or sum) when all cat* have "0" to get 125, 33, 44. This output seems to disappear but I need to show numbers when no one has "1" in DB1

---

I have no idea what that means.

Please create a small precise example of input and the results you want.  Explain in detail how you get that results from that input.  Spell out the STORY.  What do the CAT1 to CAT5 variables represent? What do the other two variables represent?  What to the observations in the input represent?  What do the observations in the output represent? What do the variables in the output represent?

Are you asking to create variables other than the 5 that exist in the data?  How do you know how many variables there could be? 

[NewUsrStat]

So, regarding CAT =0 I mean just to add the frequencies when all cat*(s) in DB1 are 0 (no "1" index). This means to report 125, 33 and 44 relative to place 1, 2 and 3 respectively in the output you provided.

[Ksharp]

data DB1;
input cat1 cat2 cat3 cat4 cat5 place value;
cards;
0 0 0 0 0 1 125
0 0 0 0 0 2 33
0 0 0 0 0 3 44
0 0 1 0 0 1 2
0 0 1 0 0 2 .
0 0 1 0 0 3 1
0 1 0 0 0 1 .
0 1 0 0 0 2 .
0 1 0 0 0 3 .
0 1 0 1 0 1 65
0 1 0 1 0 2 36
0 1 0 1 0 3 43
0 1 1 0 0 1 .
0 1 1 0 0 2 .
0 1 1 1 0 1 4
0 1 1 1 0 2 2
1 0 0 0 0 1 164
1 0 0 0 0 2 516
1 0 0 0 0 3 619
1 0 1 0 0 1 5
1 0 1 0 0 2 1
1 0 1 0 0 3 2
;

proc sql;
create table want as
select 0 as cat,place,sum(value) as value from DB1 where sum(cat1,cat2,cat3,cat4,cat5)=0 group by place
union
select 1,place,sum(cat1*value) from DB1 group by place
union
select 2,place,sum(cat2*value) from DB1 group by place
union
select 3,place,sum(cat3*value) from DB1 group by place
union
select 4,place,sum(cat4*value) from DB1 group by place
union
select 5,place,sum(cat5*value) from DB1 group by place
;
quit;