topic sum of obsevations in SAS Programming

sum of obsevations

Vijay77 — Fri, 20 Sep 2019 07:16:25 GMT

Hi,

I have following data i need count of first three obs in fourth obs with var as tot and count of next three(5,6,7) in obs 8 as var tot

eg:

obs var cnt

1 eg 3

2 eg 4

3 eg 5

4 tot 12

5 rt 3

6 rt 4

7 rt 1

8 tot 8

Re: sum of obsevations

PeterClemmensen — Fri, 20 Sep 2019 07:24:54 GMT

Is this for reporting purposes or do you want a new data set like this?

Re: sum of obsevations

Vijay77 — Fri, 20 Sep 2019 07:30:49 GMT

Hi,

i want data set like these

Thanks

Re: sum of obsevations

PeterClemmensen — Fri, 20 Sep 2019 07:35:14 GMT

I'm guessing this is what you want..

data have;
input var $ cnt;
datalines;
eg 3
eg 4
eg 5
rt 3
rt 4
rt 1
;

data want(drop=s);
    do _n_=1 by 1 until (last.var);
        set have;
        by var notsorted;
        s+cnt;
        output;
    end;
    var='tot';cnt=s;
    output;
    s=0;
run;

Re: sum of obsevations

Vijay77 — Fri, 20 Sep 2019 07:43:44 GMT

Thank you