Dear John,
Thanks.
I'll try and feed back.
Gillani.
----- Original Message -----
From: "Wallace, John" <[email protected]>
To: <[email protected]>
Sent: Friday, May 07, 2004 8:59 PM
Subject: st: RE: Merge Question
> It sounds like a merge and reshape problem to me. In the FirstV dataset
> call your cholesterol variable something like chol_0, then rename the
> variables in the RepeatV dataset chol_6, chol_12, chol_18, chol_24 etc.
> Merge uniqueID using RepeatV, which should put everything in a wide format
> dataset. Then you want to do something like -reshape long chol_,
> i(uniqueId) j(month)- which should give you UniqueID, month and chol_
> (containing the chemistry measure) as variables (month will be
> 0,6,12,18...60). You can then do whatever comparison you'd like between 0
> and 60 datapoints.
>
> Hope this helps
>
> John Wallace | Research Associate | Test Method Development
> AFFYMETRIX, INC. | 3380 Central Expressway | Santa Clara, CA 95051 | Tel:
> 408-731-5574 | Fax: 408-481-0435
>
>
> -----Original Message-----
> From: Syed Gillani [mailto:[email protected]]
> Sent: Friday, May 07, 2004 4:50 AM
> To: [email protected]
> Subject: st: Merge Question
>
> Hi,
>
> I have two related files ... FirstV and RepeatV, related on uniqueID for
> FirstV.
> FirstV contains demographic data and the first result of Serun
Cholesterol.
> RepeatV contains repeated measures of the same chemistry every six months
> for a period of 5 years, recording the date of examination.
> How can I add to FirstV the last visit value from RepeatV so I may compare
> the two?
>
> Version: Stata 8.2
> Files transferred to Stata format with StatTransfer 7 from EpiInfo 6.04d.
> OS: WindowsXP professional.
>
> Gillani.
>
>
> *
> * For searches and help try:
> * http://www.stata.com/support/faqs/res/findit.html
> * http://www.stata.com/support/statalist/faq
> * http://www.ats.ucla.edu/stat/stata/
> *
> * For searches and help try:
> * http://www.stata.com/support/faqs/res/findit.html
> * http://www.stata.com/support/statalist/faq
> * http://www.ats.ucla.edu/stat/stata/
>
>
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
