Date:         Wed, 16 Jul 2008 21:53:30 -0400
Reply-To:     Bill Behrens <mngorgeman@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Bill Behrens <mngorgeman@GMAIL.COM>
Subject:      Re: NFL Win Ratios
Comments: To: Arthur Tabachneck <art297@NETSCAPE.NET>

Hi Art,

 Sorry that I didn't paste my solutions, I had a similar solution too but
I guess I did not ask the question right. Your code and my code finds the
win ratios, that's fine. But what I need is actually a little more
complicated. After computing them I need to place the winning ratios in
their respective positions. For example,
Week 1
Sunday, September 15
MIN 32 at GNB 17
DAL 24 at ATL 0
PHI 3 at SLC 7
SFO 17 at NOR 13
WAS 13 at NYG 10
LAM 17 at DEN 10
DET 9 at CHI 17
SDG 14 at HOO 21
NYJ 16 at KAN 24
CLE 7 at CIN 33
BLC 0 at PIT 30
MIA 24 at NWE 34
============

I need to turn this into the following column form eventually:

Visiting_Team Home_Team W_L_Visiting_Team W_L_Home_Team

After sorting and calculating the ratios the data is in completely
different form than this one. I tried doing TRANSPOSE before calculating
the ratios but to no avail. Clearly I am trying to make it look like a
panel data where weeks are time indices and teams are ids. It's crucial
that all the games for Week 1 is done first and then Week 2 and so on. Do
you have any suggestion?

 Bill