Hello. I have a data set that has the following structure.
hhcode member_id age
1 1 45
1 2 23
1 3 31
2 1 50
2 2 38
2 3 31
2 4 14
3 1 65
3 2 31
3 3 15
I want to make it as follows.
hhcode age_1 age_2 age_3 age_4
1 45 23 31 .
2 50 38 31 14
3 65 31 15 .
Thank you.
Related Posts with Making household-level variables using individual-level variables
Static Model with xtabond2Dear Users, I have the following equation for panel data xtreg zer esg cap turn tdrdta prbv betal …
Find unobserved valuesHey guys, I am currently trying to figure out how to find unobserved values. I have different sic c…
choropleth map stretched outHi everyone, I'm using Stata 16 to make a chloropleth map of Connecticut. Reading the posts on here,…
Updating input output models using RAS methodHappy new year! Is there any tool that enables to update IO tables in STATA? …
How to solve auto-correlation using unbalanced panel with gapsHi all, I am dealing with unbalanced panel data with gaps, it is a survey to manufacturer companies …
Subscribe to:
Post Comments (Atom)
0 Response to Making household-level variables using individual-level variables
Post a Comment