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?
could not calculate numerical derivatives -- flat or discontinuous region encounteredDear all, I am trying to run the stochastic frontier model based on Battese and Coelli (1995), whic…
Creating two month intervalsHello, I would like to create a date variable that represent successive two month intervals - e.g., …
Pooled Panel or Cross Sectional DataGood Morning I have a query regarding a data set I am handling. I am trying to see the out migration…
Pooled Panel or Cross Sectional DataGood Morning I have a query regarding a data set I am handling. I am trying to see the out-migration…
Summary Statistics for Categorical VariablesDear Statalist, I used the following command Code: sum influenced ibn.size and was wondering if …
Subscribe to:
Post Comments (Atom)
0 Response to How can I count the observations by year (intervals) AND by country?
Post a Comment