topic calculate sum in SAS Programming

calculate sum

meetagupta — Tue, 01 Oct 2019 21:58:23 GMT

Hi, Below is the dataset that I have. i want to calculate sum of weekday 1&7(10450+34876) and sum of weekday 2 to 6(5670+78201+..)

How can I do that?

Thanks for all your help

weekday sum

1 10450

2 5670

3 78201

4 8723

5 60981

6 8921

7 34876

Re: calculate sum

ballardw — Tue, 01 Oct 2019 22:17:41 GMT

One way is to create format that will group values as you want.

proc format library=work;
value myweekdays
1,7 = '1 7'
2 - 6 = '2 to 6'
;
run;

data have;
 input weekday      sum;
datalines;
1               10450
2                5670
3                78201
4                8723
5                60981
6                8921
7                34876
;
proc means data=have sum;
   class weekday;
   format weekday myweekdays.;
   var sum;
run;

Groups of values created with a format can be used in almost any analysis, graphing or reporting procedure to create the needed groups.

Re: calculate sum

ChrisNZ — Tue, 01 Oct 2019 22:26:29 GMT

In the actual data:

You only expect 2 numbers at the end?

The first field is not a date?

Re: calculate sum

meetagupta — Wed, 02 Oct 2019 12:08:23 GMT

It worked! Thank you.