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
How to insert control variables and the command 'by' in xtabond2 ?Hello all, I am doing a research on the Persistence of Profit in the banking sector in 14 emerging c…
extract the year from an inconsistent string date variableHi everyone, I am having troubles extracting the year from my dateset. Some observations have the f…
Uncertainty Indexi am trying to construct an uncertainty index using STATA and would like help with commands …
Dummy variable omitted due to collinearityHello, I am doing a 3sls regression on int remittance and poverty among developing countries. So, fo…
Transforming datatableHi! I have a question about transforming my data table. I have a table with 3 variables: postal co…
Subscribe to:
Post Comments (Atom)
0 Response to Need help with dataset with multiple dates
Post a Comment