Date: Mon, 2 Aug 2010 10:55:18 -0400
Reply-To: art297@NETSCAPE.NET
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Arthur Tabachneck <art297@NETSCAPE.NET>
Subject: Re: Data steps arrays & REG
In-Reply-To: <OF96EC30C7.2568F6C0-ON80257773.0050CB16-80257773.0050FB1B@sqa.org.uk>
Content-Type: text/plain; charset="utf-8"; format=flowed
List,
Jake wrote me offline, but I don't have time this morning, thus here is
what he wrote:
Art
-----Original Message-----
From: Jake.Adamson@sqa.org.uk
To: Arthur Tabachneck <art297@NETSCAPE.NET>
Sent: Mon, Aug 2, 2010 10:44 am
Subject: Re: Data steps arrays & REG
Hi Arthur,
thanks for getting back so quickly. The data set has these variables:
RaceAV, HorseAV1-HorseAV40, HorseID1-HorseID40
For example, each observation has the race average and then the horse
averages for each horse that ran in the race.
Jake.
From:
Arthur Tabachneck <art297@NETSCAPE.NET>
To:
SAS-L@LISTSERV.UGA.EDU, Jake Adamson <Jake.Adamson@SQA.ORG.UK>
Date:
02/08/2010 15:26
Subject:
Re: Data steps arrays & REG
------------------------------------------------------------
Jake,
Difficult to say without knowing what your data actually look like.
However, that said, one possibility might be to expand your data with a
Cartesian join (see, e.g.: http://www.listserv.uga.edu/cgi-bin/wa?
A2=ind0506D&L=sas-l&P=R29923&D=1&H=0&O=D&T=1&m=173493
or, in short form: http://xrl.us/bhuy82 Â )
and then using a by statement when running your proc reg.
HTH,
Art
---------
On Mon, 2 Aug 2010 15:06:42 +0100, Jake Adamson
<Jake.Adamson@SQA.ORG.UK>
wrote:
>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
>**********************************************************************
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
**********************************************************************
