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

st: problem with merge


From   "Ann E Fitzmaurice" <a.e.fitzmaurice@abdn.ac.uk>
To   <statalist@hsphsun2.harvard.edu>
Subject   st: problem with merge
Date   Tue, 7 Jun 2005 11:29:28 +0100

Hi

I have variables of the format in one file from dhs
caseid1
1002 9
100211
in a separate file I concatenate two variables and the format becomes
caseid1
10029
100211
what I would like to do is to eliminate the blanks from the variables in
each file using trim but cannot get it to work, and then to split the
variable caseid1 into two variables to remove the blank in the middle and
then rejoin the two variables so that I can merge

the one file has details relating to household, one line per household, the
second file has details relating to the household member so want the
household details to be applied to all household members
can anyone help

regards

ann

Ann E Fitzmaurice
Medical Statistician

University of Aberdeen
Department of Obstetrics & Gynaecology
Aberdeen Maternity Hospital
Cornhill Road, Aberdeen.  AB25 2ZL

Tel:  +44 (0) 1224 553876
Fax: +44 (0) 1224 553708
e-mail: a.e.fitzmaurice@abdn.ac.uk
http://www.abdn.ac.uk/dugaldbairdcentre/

 



*
*   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