I don't know what "does not seem to work" means in your case, but one way forward is something like this.
First, segregate observations that are good and bad for your purpose. Let's say "good" observations are non-missing on these variables and positive on -var-.
gen byte good = !missing(year, Country, var) & (var > 0)
Second,
bysort good Country year : egen rank_var = rank(var)
Third, use only
... if good
Nick
[email protected]
[email protected]
Further to my query below:
I just found that I have a number of missing and negative values. Is there anyway I can exclude these cases when I assign the country ranks?
[email protected]
> I am trying to assign ranks to country observations within
> years. By this I mean that I want to assign a score for each
> observation (within a country) within that specific year.
> So far, I have calculated:
> egen rank_var = rank(var) ---- this seems to provide ranks to
> countries, but does not take into account yearly changes.
> I tried:
> bysort year Count: egen rank_var= rank(var)--- but this does not
> seem to work either. Is this something to do with subscripting?
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
