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
Table of descriptive data. Possible to switch rows and columns using tabstat?Hello, In my dataset I have 3 groups (1, 2, 3) and 20 continous variables (A, B, C, etc. ) for each …
Add shade in the graphDear all, I want to add shade in my graph when the variable corr_x is negative. Code: * Example ge…
Correlation between two long time seriesDear all, I want to test the correlation between two time series with large T, for example, the pri…
mean comparison for panel dataDear All, I have a panel data with three waves and i am comparing the mean difference (mean comparis…
Add shade in the graphDear all, I want to add shade in my graph when the variable corr_x is negative. Code: * Example ge…
Subscribe to:
Post Comments (Atom)
0 Response to Need help with dataset with multiple dates
Post a Comment