Hi there Statlist community!
I am currently working on summarizing home value appreciation by neighborhood over time, and am wondering if there's a smarter way to do what I'm doing. In order to get median home values for each year by neighborhood, I've been doing
bysort saleyear: sum saleprice if neighborhood==1, detail
for each neighborhood, which has been time-consuming and cumbersome for my ultimate goal of a nicely-formatted multiple line graph in excel (with one line for each neighborhood, values on the y-axis, and year on the x). Does anyone have any ideas for a smarter, smoother way to do this? Thank you so much in advance for your help and best wishes!
Related Posts with Getting medians for different x variables across years
Why the different bootstrap errors in panel data random effects?Hi, in help xt_vce_options I found the following recommendation: When working with panel-data mode…
Nested forvalue loops - referring to previous macros in a relevant macroGood afternoon. Could anyone help me decipher what syntax error I am producing in the below command…
Is it possible to not set values of optional integer arguments with the syntax commandWhen specifying optional arguments integer arguments using the syntax command it is usually necessar…
Detecting inverted duplicates over two columnsHello, I have searched for an answer to this simple question on previous forums, and cannot find the…
Keep the first observation within a moving 30-day windowI have the following dataset. I want to keep d=1 for the first observation within 30-day moving wind…
Subscribe to:
Post Comments (Atom)
0 Response to Getting medians for different x variables across years
Post a Comment