Dear all,

I would like to ask you wheter it is possible to get information (mainly about number of observation but also mean, SD etc.) from second level variables only.

I am working with pane-level data (2 levels) and when I use -sum- command I get information per every single observation, but I'd like to get this information from the second level only (country level in my case). So the information from 1st level cases agregates to the second level. Is that possible?

Thank you for your help.

Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input byte countrylevel double A_90ss int democracy double enep
 1   9.29 45     3.17
 1  9.563 49     3.87
 1  3.825 50     3.59
 1   9.29 54     3.82
 1 18.579 57     3.02
 1  5.464 61     3.71
 1 14.208 63     4.79
 1 10.929 68 5.149357
 1  16.94 72        .
 2   5.66 45     9.81
 2  4.597 49     9.35
 2  7.667 53    10.29
 2 11.667 57     8.84
 2 10.667 61     9.04
 2 14.333 64    10.04
 2  9.333 68 9.447867
 5  8.929 21     3.67
 5  3.571 26     3.79
 5  4.464 31     3.76
 5  8.036 36     4.29
 5  5.357 41     3.85
end