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
Reshaping Data for Analyzing Experiments with Fractional Factorial Designs Dear Stata community, I need to reshape/reorganize my data for analyzing the results of a survey e…
Difficulty with Stata Manuals in SumatraPDFDear Statalist, I am having some trouble with the Stata manuals when using SumatraPDF (v3.2 64-bit …
model specification and implications of time invariant variables with mixedHi all, I've read through some other forum posts similar to this topic, but didn't think they were …
Logistic regression interactions testHello! I have a logistic regression model that keeps failing the goodness of fit test. The unweight…
Problems calculating the change in vote share from incumbent candidates (electoral data)Hi all. I have a dataset with electoral municipal information for Brazilian municipalities from 2000…
Subscribe to:
Post Comments (Atom)
0 Response to summary stats with years
Post a Comment