SAS dataset count winning streak on baseball

Asked Jul 04 '16 at 02:29

Active Jul 07 '16 at 05:42

Viewed 88 times

Hi: I am processing baseball dataset. I want to count the winning streak of a team winning. I created a variable called win, if team A wins it is 1, else it is 0. I want to create a variable called winstreak, if team A wins 1 time, it is 1, if team A wins 2 in a row, it is 2, if team A loses it goes back to 0 again. So far I have tried:

data phi2002;
  set phi2002;
  retain winstreak;

  if (VisitingTeam = "PHI" and VisitorRunsScored > HomeRunsScore)
    then PHIWIN = 1;
  else if (HomeTeam = "PHI" and HomeRunsScore > VisitorRunsScored)
    then PHIWIN = 1;
  else PHIWIN = 0;

  if PHIWIN = 1 then winstreak =+1;
  else winstreak = 0;
run;

The code doesnt work, since winstreak only shows the same value as PHIWIN. Please help!

edited Jul 07 '16 at 05:42

Dominic Comtois

10,230
1
39
61

asked Jul 04 '16 at 02:29

Richard Li

I'm assuming you mean streak not steak ;) – Reeza Jul 04 '16 at 02:37
I don't know if this is valid SAS code 'winstreak =+1' try winstreak+1 instead. – Reeza Jul 04 '16 at 02:38
I tried it, it just changes winsteak value to 2 instead of 1, but its the same as phiwin. – Richard Li Jul 04 '16 at 03:07
Thats because your else statement resets it. Change your else. – Reeza Jul 04 '16 at 03:33
with the `=+` -> `+` correction it works for me – DaBigNikoladze Jul 04 '16 at 10:12
Thank you! It works for me now – Richard Li Jul 04 '16 at 19:58

SAS dataset count winning streak on baseball

0 Answers0