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

st: RE: Merge Question


From   "Wallace, John" <John_Wallace@affymetrix.com>
To   "'statalist@hsphsun2.harvard.edu'" <statalist@hsphsun2.harvard.edu>
Subject   st: RE: Merge Question
Date   Fri, 7 May 2004 10:59:23 -0700

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/



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