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
mixed with 2 time pointsHi, I am trying to build a random intercept/random slope model with longitudinal data (time is nest…
Trouble with repeated dates and panel creationHi all, I have the following issue, I want to create a panel out of data that contains a code (the p…
Subsample in Panel data By MedianHello all, I have another question and hopefully you can help me (as already done several times) I a…
Mediation Analysis in stata with non continuous mediator- Test statistics?Dear all, I need to run two mediation analysis for a research project and after having studied the …
Testing Replication Code + Best PracticeI am preparing my replication files for an article that has been accepted subject to replication che…
Subscribe to:
Post Comments (Atom)
0 Response to summary stats with years
Post a Comment