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?
U test for Inverted U-shapeHello, I am looking at whether there is a threshold upon which the total value traded of all stocks…
comparing the effect and magnitude of two coefficients across two modelsHello everyone, I have a panel dataset with 500 banks (in 20 countries) over the period 2000-2015. …
Graph box over sex, side by side boxesHi folks, Apologies if this question is simple but I was trying to find a good solution. I want to…
two notes when using twoway graph, by()Hi all, I'm making a graph (see below) that uses the twoway graph by() option. As you can see, beca…
Updated combomarginsplotGreetings, An updated combomarginsplot is now available on SSC (thanks Kit Baum!). This version has…
Subscribe to:
Post Comments (Atom)
0 Response to How can I count the observations by year (intervals) AND by country?
Post a Comment