unique

  1. M

    egen count only but unique values

    Hello, Below is how my dataset looks like: GranteeID ProviderID 11 11 12 11 26 27 78 27 78 27 33 33 33 33 33 33 I am trying to count the number of unique GranteeIDs by ProviderID. This is my attempt: egen grantee_count = count(GranteeID), by(ProviderID). However, grantee_count is not...
  2. M

    Linear Regression while comparing results?

    Hi all I am working on a research project for a basic stats course. I'm in the planning phase and could use some pointers to make sure I'm going in the right direction. Question: How do I do a linear regression while assuring that the dependent variable is unique for each set of distinct...
  3. M

    Loop within subgroup

    I'm trying to have R go through a loop within ID groups, and within each group: - find the max year; - count the number of prior observations (by year) that have a code other than the code corresponding to the current row; - disregard observations that appear in the same year. I would very...
  4. S

    Unique Counts and Averages over Subgroups

    Hi all, This is kinda similar to the question I had last week, but I think its a little more complicated. Basically I have two variables, and I want to perform actions in relation to unique combinations of these variables. DATE TIME PLAYER SCORE 2012/8/1 Evening BOB...