topic Re: sum function in SAS Programming

sum function

BaalaRaaji — Thu, 25 Oct 2018 00:37:49 GMT

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

Re: sum function

Reeza — Thu, 25 Oct 2018 01:09:11 GMT

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

Re: sum function

Shmuel — Thu, 25 Oct 2018 01:15:19 GMT

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 ?

Re: sum function

novinosrin — Thu, 25 Oct 2018 01:33:09 GMT

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

Re: sum function

BaalaRaaji — Thu, 25 Oct 2018 01:53:18 GMT

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

appreciate everyone for quick replies.thank you

cheers!

Re: sum function

LinusH — Thu, 25 Oct 2018 06:03:12 GMT

Then please share for other to learn!