Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: Re: RE: Merge Question


From   "Syed Gillani" <syed@saudionline.com.sa>
To   <statalist@hsphsun2.harvard.edu>
Subject   st: Re: RE: Merge Question
Date   Fri, 7 May 2004 22:25:40 +0300

Dear John,
Thanks.
I'll try and feed back.
Gillani.

----- Original Message -----
From: "Wallace, John" <John_Wallace@affymetrix.com>
To: <statalist@hsphsun2.harvard.edu>
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:gillani@shabakah.net.sa]
> Sent: Friday, May 07, 2004 4:50 AM
> To: statalist@hsphsun2.harvard.edu
> 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/



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index