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
0 Response to summary stats with years
Post a Comment