Good day,
So I have a data set (panel data) counting lots of variables. But for now I am only interested in counting the observations of each year (period) and the corresponding country.
So for example: I have multiple observations on Argentina for year period 1, and I have also multiple observations on Argentina for year period 2... and so on.
In total, there are 6 time periods.
(Only 10 countries in the first period, but for example up to 60 countries in period 6)
I have tried to work with distinct however when using ed Stata gives me a list of all my observations without summing the periods/countries in one row.
I would like to retrieve a table that counts the number of observations for each country within each time period.
Please do not get confused about the year periods, it just serves as a time variable.
Thank you very much in advance!
Related Posts with How can I count the observations by year (intervals) AND by country?
Looping and importing excel sheetsHi all, I am importing 12 files from excel. These worksheets have common name starting from II1 to …
Test overidentification when instrumenting xtivreg2 with predicted values of xtpoissonDear all I have two questions, one stata question and another econometric question. First the stat…
How to get a graph line with multiple variables in the x-axis?Hi everyone, I have a tricky question regarding the line graph with multiple variables. My problem…
Help Panel Var..can't get over this!!Hello guys, I don't know if someone will be so nice to help me with this, but I'm trying to get to …
Add histogram of values distribution when graphing conditional marginal effects?Hi all, I am learning about graphing the marginal effects of a variable conditional on the values o…
Subscribe to:
Post Comments (Atom)
0 Response to How can I count the observations by year (intervals) AND by country?
Post a Comment