Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Count how often an ID occurs in a column

    Hi,

    I have a question which should be fairly easy to answer. I have a variable in my dataset called ind_id (individual ids). I want to get an overview of how often each ID occurs in the column. Ideally, I could also perform some basic descriptive statistics on the result (i.e. max/min, average, percentile). Thanks for your help.

    Best, Valentin

  • #2
    Code:
    by ind_id, sort: gen id_count = _N if _n == 1
    summ id_count, detail

    Comment

    Working...
    X