Hi I am working with a dataset which ahs multiple dates for the same diagnosis for a patient and I only want to keep the observations with the earliest date and drop the rest. I am going to explain a bit how the dataset is so that it can be understandable.
ID DIAGNOSIS DATE
1 CKD 2/9/2000
1 CKD 4/7/2008
1 CHF 2/5/2005
1 CHF 5/5/2009
What I want it to like is to have a column of diagnosis and only the first date.
Please help me out. Thanks
Ushma
Related Posts with Need help with dataset with multiple dates
Using loop for wrapping up multiple merge commandsHi, I was wondering if a loop can wrap up below two merge commends. Thanks, NM use impute0, cle…
IIA assumption test after conditinal logitHi, Is there any way to test IIA assumption following conditional logit(clogit)? Found it for mlogit…
quartilesI want to do table like this but i dont know how to do it can any one help me with codes? Array…
Interaction term in DGMMHi all, I have a concern with respect to the interaction term as follows: My panel dataset includes…
Moderation analysisHello all, I am currently writing my thesis and testing some hypotheses. With one of my hypotheses,…
Subscribe to:
Post Comments (Atom)
0 Response to Need help with dataset with multiple dates
Post a Comment