Date:         Thu, 3 May 2007 12:53:37 -0700
Reply-To:     Jeanina Worden <jworden@PDD.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Jeanina Worden <jworden@PDD.NET>
Subject:      Re: A Transpose question
Comments: To: sanjay sun <sanjaysum@GMAIL.COM>
In-Reply-To:  A<83ceb37a0705031243x6ceacf07k3fc5380674f3730f@mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"

add site to your BY statement

-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU]On Behalf Of
sanjay sun
Sent: Thursday, May 03, 2007 12:44 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: A Transpose question


Hi Group,

I was trying to transpose a data set that was in this structure

Site       SubjectID
Date                  Test
Value                            Unit                         Window

1               1
01/06/07             L                           1.1
mg/DL                         Baseline

1              1                   02/08/07
L                            1.9
mg/DL                           Week4

1              2                     01/06/07
L                             1.2
mg/DL                           Baseline

1              2                     02/09/07
L                            1.4
mg/DL                          Week4


I want it in this form

Site                  SubjID                 Baseline
Week4

1                       1                        1.1
1.9
1                       2                        1.2
                              1.4



I used the following code


*

proc* *transpose* data=lab out=trans* *prefix=Window;

by subjID;

var Value ;
*

run*;

**

*Everything was fine but in the output I got I was not getting site. How can
I get it?*

*thanks alot.*

**

*Sanjay*

**

**