Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Is there a unique “key” that identifies unique records in the DCCT adverse events analysis dataset (m9exevet)?

April 26, 2017adverse analysis dataset dcct events identifies key records

0

10 Posted

Is there a unique “key” that identifies unique records in the DCCT adverse events analysis dataset (m9exevet)?

1 Answer

0

10 Posted

A. This is one of those datasets for which a unique key must be created, if needed. For most “adverse events”, the combination of patient ID (mask_pat) plus date (eventday) will be unique for the vast majority of events. However, some patients will have multiple events on the same day. To make a unique key, you must construct a counter that identifies the 1st, 2nd, 3rd, etc. event on a given day.