Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down on April 23, and its replacement, statalist.org is already up and running.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

st: combining different observations from a person


From   "Dudekula, Anwar" <dudekulaan@upmc.edu>
To   "statalist@hsphsun2.harvard.edu" <statalist@hsphsun2.harvard.edu>
Subject   st: combining different observations from a person
Date   Mon, 5 Nov 2012 08:44:17 +0000

Hi Stata List subscriber , 

I have a dataset with multiple observations for many patients.
I have included two observations for the same patient that were formed when two data sets were appended.
*******************************************************************************************************************
			              Numericalvar1	Numericalvar2 StringVar3 Stringvar4 Stringvar5  Numericalvar6 
observation 1 Patient 1 		0		2	Male 	   abdomen 	
Obervation 2 Patient 1 		1		2				chest		3
******************************************************************************************************************
Observation 1 doesnt have any  values for var5 and var6 
Observation 2 has a different value for Var1, same value for var2 , no value for var3 and var 4 
I need to combine the two observation so that I get a final observation as follows 
*****************************************************************************************************************
   			           Numericalvar1 Numericalvar2 StringVar3 Stringvar4 Stringvar5  Numericalvar6 
observation   Patient 1 		1		2	             Male 	   abdomen 	chest		3
******************************************************************************************************************

Please advise . 
Thanks you 
Anwar 

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/faqs/resources/statalist-faq/
*   http://www.ats.ucla.edu/stat/stata/


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