Date:         Mon, 2 Aug 2010 14:06:03 -0400
Reply-To:     Arthur Tabachneck <art297@NETSCAPE.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Arthur Tabachneck <art297@NETSCAPE.NET>
Subject:      Re: Proc reg

Jake,

I'd even ask for more than what Mark was suggesting you present.

For example, given the following sample data for races that only have 5
horses:

data have;
  informat horseid1-horseid5 $40.;
  input race
        horse1-horse5
        horseid1-horseid5;
  cards;
50 20 10 60 80 30 kentucky_jones hazards_of_love poetic_soul power_move
jelly_roll
40 30 35 50 45 40 kentucky_jones gore_bay poetic_soul skootin jelly_roll
60 50 55 70 65 60 gore_bay poetic_soul skootin glitter_box hazards_of_love
power_move
;

(1) please show a data step that would represent the file you ultimately
would want to result from data have and (2) show the various regressions
you would want run based on that data.

Art
----------
On Mon, 2 Aug 2010 17:49:18 +0000, Keintz, H. Mark
<mkeintz@WHARTON.UPENN.EDU> wrote:

>Jake:
>
>I think you need to give a clearer description of your data structure,
maybe with a couple sample observations.
>
>Regards,
>Mark
>
>> -----Original Message-----
>> From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
>> Jake Adamson
>> Sent: Monday, August 02, 2010 9:26 AM
>> To: SAS-L@LISTSERV.UGA.EDU
>> Subject: Proc reg
>>
>> Hi all,
>>
>> I have a question about proc reg. It is to do with sports analysis and
>> involves horseracing. If I have one variable which is the overall
>> average
>> race rating (Race) and is the average of each horses average rating
>> that
>> ran. Then numerous variables (HORSE)  that store the average horse
>> rating
>> with a corresponding variable HORSEID that stores the horse's name so
>> that
>> the code looks like:
>>
>> Proc Reg data=sample;
>> Model RACE = HORSE: ;
>> Run;
>>
>> Is there some way i can build the array capacity into the proc reg
>> statement so that SAS reads HORSE1 on one observation as being
>> different
>> to HORSE1 on another observation. So that HORSE1 is linked to HORSEID1
>> and
>> a regression between the two is only made when the horse's names are
>> the
>> same?
>>
>> Many thanks,
>>
>> Jake.
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> Please save a tree. Don't print this message unless you really have to.
>>
>>
>>
>>
>> **********************************************************************
>> This message contains confidential information and is intended only for
>> the individual named. If you are not the named addressee you should not
>> disseminate, distribute or copy this e-mail. Please notify the sender
>> immediately by e-mail if you have received this e-mail by mistake and
>> delete this e-mail from your system. E-mail transmission cannot be
>> guaranteed to be secure or error-free as information could be
>> intercepted, corrupted, lost, destroyed, arrive late or incomplete, or
>> contain viruses. The sender therefore does not accept liability for any
>> errors or omissions in the contents of this message, which arise as a
>> result of e-mail transmission.
>> WARNING: Computer viruses can be transmitted by e-mail. The recipient
>> should check this email and any attachments for the presence of
>> viruses. SQA accepts no liability for any damage caused by any virus
>> transmitted by this email.
>> Scottish Qualifications Authority
>> www.sqa.org.uk
>> postmaster@sqa.org.uk
>> **********************************************************************