Dear all,
do you know if there is a quick and easy way to produce summary stats with a column containing list of all the years in which a variable has observations (no missings)?
I want it to look like this:
| N Mean p50 p10 p90 Min Max SD years
-------+----------------------------------------------------------------------------------------------------------------------------------
hid | 341487 1304643 510564 33499 3307726 19 5540404 1378070 1984...2022
solar | 13055 .1162773 0 0 1 0 1 .3205694 2015, 2020
// hid was part of the questionnaire in every wave of the SOEP between 1984 until 2022
//solar was part of the questionnaire just in 2015 and 2020
best regards
Philipp
Related Posts with summary stats with years
Percentiles and data trimmingGood morning I tried to find an answer to my (apparently) easy question on the forum, but probably i…
Gini index interpretation - time use dataHi everyone, I am using Italian Time Use surveys to analyze parental time investments. I used ineqde…
How to interpret regression results if dependent variable is logged and independent variables are standardized?Array In my fixed effects panel regression analysis the DV (Triadic Patent Families) enters in logar…
Asset/wealth index with PCABackground: We are studying a rural population of 375 malawian households, and are trying to make an…
Hiding bar of one category in -tabplot-Dear users, I am using -tabplot- to realize the following graph (see attachment) and I would like to…
Subscribe to:
Post Comments (Atom)
0 Response to summary stats with years
Post a Comment