topic Re: to find total runs and overs in a cricket match in New SAS User

Find out Total Runs And Overs In A Cricket Match

rohithverma — Mon, 09 Sep 2019 10:11:09 GMT

I have two variables like overs and balls and i need to find the total count of overs and total number of runs?

input data :

overs runs

1 2

2 4

3 0

4 1

5 1

6 5

1 2

2 4

3 0

4 1

5 1

6 5

i need output like

overs runs

2 26

Re: to find total runs and overs in a cricket match

PeterClemmensen — Mon, 09 Sep 2019 10:09:48 GMT

Why is overs=2 in your output?

Re: Find out Total Runs And Overs In A Cricket Match

Jagadishkatam — Mon, 09 Sep 2019 10:13:15 GMT

please try

data want;
input overs runs ;
cards;
1 2
2 4
3 0
4 1
5 1
6 5
1 2
2 4
3 0
4 1
5 1
6 5
;

proc sort data=want;
by overs;
run;

data want2;
set want;
by overs;
retain cnt;
if first.overs then cnt=1;
else cnt+1;
run;

proc sql;
create table want3 as select count(distinct cnt) as overs, sum(runs) as runs from want2 ;
run;

Re: to find total runs and overs in a cricket match

rohithverma — Mon, 09 Sep 2019 10:14:25 GMT

Per Over 6 balls, here we are consider only 2 overs. However expected output will be 2 overs.

Re: Find out Total Runs And Overs In A Cricket Match

Jagadishkatam — Mon, 09 Sep 2019 10:17:05 GMT

Alternatively in a data step without proc sql

data want;
input overs runs ;
cards;
1 2
2 4
3 0
4 1
5 1
6 5
1 2
2 4
3 0
4 1
5 1
6 5
;

proc sort data=want;
by overs;
run;

data want2(rename=(cnt=overs sum=runs));
set want end=eof;
by overs;
retain cnt;
if first.overs then cnt=1;
else cnt+1;
sum+runs;
if eof;
keep cnt sum;
run;

Re: to find total runs and overs in a cricket match

PeterClemmensen — Mon, 09 Sep 2019 10:18:27 GMT

Ok. I think this gives you what you want

data want(drop=_:);
    do until (lr);
        set have end=lr;
        _runs+runs;
        if overs=1 then _overs+1;
    end;
    runs=_runs;overs=_overs;
run;

Re: to find total runs and overs in a cricket match

rohithverma — Thu, 14 Nov 2019 08:23:35 GMT

I am unable to understand that why can't we use

" _overs=_overs+1 " in place of "_overs+1" . Could you Please explain the difference between the two if possible.

data want(drop=_:);
    do until (lr);
        set have end=lr;
        _runs+runs;
     if overs=1 then _overs+1;
    end;
    runs=_runs;overs=_overs;
run;