sum function

[BaalaRaaji]

Hi , below is the sample dataset.

date	bucket	bal
30-Sep-18	0	10
30-Sep-18	1	20
30-Sep-18	2	30
30-Sep-18	3	40
30-Sep-18	4	50
30-Sep-18	5	60
30-Sep-18	6	70
30-Sep-18	7	80
30-Sep-18	9	90

I wanted to sum the values using SUM function..

if bucket in '(1,9) then balance else display the balance. like below

below table

30-Sep-18	0	10
30-Sep-18	1	110	20+90	bucket 1& 9)
30-Sep-18	2	30
30-Sep-18	3	40
30-Sep-18	4	50
30-Sep-18	5	60
30-Sep-18	6	70
30-Sep-18	7	80
30+	sum(of bucket >2)
90+	sum(of bucket >4)

appreciate your help.thanks RS

[Reeza]

You want a multilabel format and you likely don’t want the sum function since that works on a row. You likely want a summary procedure such as PROC MEANS. If you really want the SUM() function that would be a data step operation then.

Here’s a fully worked example of a multilabel format and how it works
https://gist.github.com/statgeek/1c6f38ef368a4272cf458b017fc63d4b

[Shmuel]

Assuming your data contains more than one day dates - should summary be per day ?

What kind of output you want - data-set or listing ? 

Please post how should final output look like. 

What code did you try ?

[novinosrin]

easy and straight forward in sql, but before that what happended to 8 in bucket and why not display 20+90 in bucket 9 as well. I'll await your response

[BaalaRaaji]

Please ignore the query.I have figure out the solution in proc sql .thanks

appreciate everyone for quick replies.thank you

cheers!

[LinusH]

Then please share for other to learn!