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
Sample size calculation using Cohen's d / Hedges's gHi everyone, Can anyone please advise me on how to perform a sample size calculation using Cohen's …
Ceo transition from male to femaleDear community, I have an unbalanced panel data where I want to create the following variables with…
After having run a robust regression, do I still need to test for heteroskedasticity?"regress indep dep control control vce(robust)" After the regression, Stata doesn't allow me to use …
_rmcoll (Drop collinear variables)Dear all, I tried to find an appropriate post which relates to my problem but I was not successfull…
Customization of graph combine with three graphsHi Statalisters I am working on a visualization where I am interested in the following graph combin…
Subscribe to:
Post Comments (Atom)
0 Response to summary stats with years
Post a Comment