LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (January 2009, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Wed, 21 Jan 2009 13:32:24 -0500
Reply-To:   Ya Huang <ya.huang@AMYLIN.COM>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   Ya Huang <ya.huang@AMYLIN.COM>
Subject:   Re: Change from Baseline Dataset
Comments:   To: ali6058@GMAIL.COM

You certainly don't want to do cartesian join then derive all the paired change, meaning, scr1 vs v1/obs1, scr1 vs v1/obs2, .. scr2 vs v1/obs1 ...

One thing you can do is to do the screening mean only, then change from each obs of each visit to the screening mean.

Another thing you can do is to pick the latest screening as the real screening, the do the change from there.

Anyway, you have to get your statistician's support.

On Wed, 21 Jan 2009 10:22:47 -0800, Al <ali6058@GMAIL.COM> wrote:

>On Jan 21, 10:22 am, ya.hu...@AMYLIN.COM (Ya Huang) wrote: >> You may have to average each visit including screening, then >> do the change of mean for each visit from the mean of screening. >> Of course, you have to ask your statistician, who might have already >> discussed this in the SAP. >> >> >> >> On Wed, 21 Jan 2009 08:12:06 -0800, Al <ali6...@GMAIL.COM> wrote: >> >Hi All, >> > I have a dataset in the following structure.. I am looking >> >to create a dataset change from Screening to visit.. >> >Strange thing is that the test was performed three times at scr and >> >three times at each visit .. so i am having trouble >> >creating the change from screening to each visit values .. i cannot >> >envision how the final dataset will look like.. >> >any suggestions... >> >> > PAT VIS TES SEQ RES >> > 111 Scr SYSBP 1 106 >> > 111 Scr SYSBP 3 106 >> > 111 Scr SYSBP 5 114 >> > 111 Vis1 SYSBP 12 116 >> > 111 Vis1 SYSBP 14 118 >> > 111 Vis1 SYSBP 16 112 >> > 111 Vis2 SYSBP 21 110 >> > 111 Vis2 SYSBP 23 103 >> > 111 Vis2 SYSBP 25 111 >> >> > 222 Scr SYSBP 1 102 >> > 222 Scr SYSBP 3 106 >> > 222 Scr SYSBP 5 98 >> > 222 Vis1 SYSBP 12 120 >> > 222 Vis1 SYSBP 14 112 >> > 222 Vis1 SYSBP 16 114 >> > 222 Vis2 SYSBP 21 105 >> > 222 Vis2 SYSBP 23 111 >> > 222 Vis2 SYSBP 25 107 >> >> > Thanks in advance >> > Al- Hide quoted text - >> >> - Show quoted text - > >I have checked the SAP .. and nothing was mentioned about doing the >averages etc .. Any more Help.. >Thanks >Al


Back to: Top of message | Previous page | Main SAS-L page