Date:         Thu, 19 Mar 2009 15:20:20 -0400
Reply-To:     Peter Flom <peterflomconsulting@mindspring.com>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Peter Flom <peterflomconsulting@MINDSPRING.COM>
Subject:      Re: Help needed with transposing data
Comments: To: Jack Clark <jclark@hilltop.umbc.edu>
Content-Type: text/plain; charset=UTF-8

Jack et al

Sorry for not being clear

Something like
ID      Hand    Gender  Forearm PRVC     PDAC    PRVE  PDAE
1       R       M       1       63      0.288     59   .298
1       R       M       2       60      0.285     61   .291
2       R       M       1       52.8    0.243
2       R       M       2       72      0.293

etc

Peter

-----Original Message-----
>From: Jack Clark <jclark@hilltop.umbc.edu>
>Sent: Mar 19, 2009 3:13 PM
>To: Peter Flom <peterflomconsulting@mindspring.com>, SAS-L@LISTSERV.UGA.EDU
>Subject: RE:      Help needed with transposing data
>
>Peter,
>
>It's not clear to me from your post what you want the transposed data to
>look like.
>
>Jack
>
>
>
>
>Jack Clark
>Senior Research Analyst
>phone: 410-455-6256
>fax: 410-455-6850
>jclark@hilltop.umbc.edu
>
>University of Maryland, Baltimore County
>Sondheim Hall, 3rd Floor
>1000 Hilltop Circle
>Baltimore, MD 21250
>
>
>
>
>Confidentiality Notice: This e-mail may contain information that is legally privileged and that is intended only for the use of the addressee(s) named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying of this e-mail, distribution, or action taken in reliance on the contents of this e-mail and/or documents attributed to this e-mail is strictly prohibited. If you have received this information in error, please notify the sender immediately by phone and delete this entire e-mail. Thank you.-----Original Message-----
>From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
>Peter Flom
>Sent: Thursday, March 19, 2009 3:06 PM
>To: SAS-L@LISTSERV.UGA.EDU
>Subject: Help needed with transposing data
>
>Apologies if this shows up twice .... the first one got rejected. Or
>seemed to get rejected.
>
>Hello again
>
>I've got a data set that looks like
>
>Scanner ID      Hand    Gender  Forearm PRV     PDA
>C       1       R       M       1       63      0.288
>C       1       R       M       2       60      0.285
>E       1       R       M       1       59      0.298
>E       1       R       M       2       61      0.291
>C       2       R       M       1       52.8    0.243
>C       2       R       M       2       72      0.293
>etc.
>
>I would like to run correlations for PRV when scanner = C vs PRV when
>scanner = A; similar for PDA.
>
>I'm playing with the data step, but getting nowhere, and do not have
>time to do more playing.
>
>Doubtless this is easy for a PROC TRANSPOSE or DATA step expert ....
>
>TIA
>
>Peter
>
>PS Note that I will be at this job for 2 hours, then back on Monday, but
>will check my e-mail.  I just won't be able to
>try out any suggestions in-between
>
>
>
>Peter L. Flom, PhD
>Statistical Consultant
>www DOT peterflomconsulting DOT com


Peter L. Flom, PhD
Statistical Consultant
www DOT peterflomconsulting DOT com