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
Creating Probability VariablesHi, I have a set of variables indicating whether there was a recession in your year of birth or not…
Can I use multiple imputed data in a principle component analysis if my data are not normally distributed?Is it possible to use multiple imputed data in a principle component analysis if my data are not nor…
Change the lenght of a stringHi, I have a dataset where the variable id is stored as a str9, although this id has only 8 charact…
Fitstat gives error messageHi all, When I use fitstat after a ologit regression, I get this message: Code: . fitstat Measur…
strmatch and backslashThere seems to be something weird about strmatch, and I just can't find out what. I'm trying to matc…
Subscribe to:
Post Comments (Atom)
0 Response to Need help with dataset with multiple dates
Post a Comment