BJ Data Tech Solution

Specialized on Data processing, Data management Implementation plan, Data Collection tools - electronic and paper base, Data cleaning specifications, Data extraction, Data transformation, Data load, Analytical Datasets, and Data analysis. BJ Data Tech Solutions teaches on design and developing Electronic Data Collection Tools using CSPro, and STATA commands for data manipulation. Setting up Data Management systems using modern data technologies such as Relational Databases, C#, PHP and Android.

How do i drop all dates, except the earliest date for specific ID variables
How do i drop all dates, except the earliest date for specific ID variables

I have a dataset where patients have specific ID-numbers. They also have one specific ID for every time they have been admitted to the hospital, which means that there are several of the same ID's but with different dates. I only need the first admission, so i need to figure out how i drop all variables with the same ID except the ID-number with the first admission. I hope that makes sense and that you can help. Thank you.

Example:
ID: 0000012354 Admissiondate: 04 mar 13
ID: 0000012354 Admissiondate: 07 jun 14
ID: 0000012354 Admissiondate: 12 jan 16

All the best
Jonas

BJ Data Tech Solution

Home / Data Cleaning / Data management / Data Processing / How do i drop all dates, except the earliest date for specific ID variables
How do i drop all dates, except the earliest date for specific ID variables

0 Response to How do i drop all dates, except the earliest date for specific ID variables

Post a Comment

Home / Data Cleaning / Data management / Data Processing / How do i drop all dates, except the earliest date for specific ID variables How do i drop all dates, except the earliest date for specific ID variables

Related Posts with How do i drop all dates, except the earliest date for specific ID variables

0 Response to How do i drop all dates, except the earliest date for specific ID variables