I am using 10 waves of the PSID data with the aim of analysing trends in household charitable giving over time. I want to create a panel with household ID as the Panel ID variable. The problem is that the household ID number is different for each household for each wave. The only identifying variable that is constant over time is at the individual level. Naturally, this wouldn't be a problem if the head of household was the same for each year but for many families the head of household changes at least once over the course of the 10 waves. I have the following variables that are of use:
id - Unique individual identification number
familyid - Unique family idenitifcaiton number (different every year)
famchange - Family composition change number (0 if no change, 1 if change other than head, 2 partner left family, 3 partner now head of household etc.)
relationtohead - Individual's relation to the head of household (20 if partner, 30 if son or daughter, 33 stepson etc.)
In my dataset I have every individual that was head of household in at least 1 wave. All of my other variables are at the household level.
How can I generate a household ID variable that is constant over time and accounts for changes in the head of household?
I have tried to use dataex but my input statement exceeds linesize limit.
Related Posts with PSID - Generating a household ID
Discrete Choice Experiment - Fractonnial factorial designDear collegues, As PhD student, I want to set up a Discrete Choice Experiment in a consumers survey…
Mediation effects with MLM?I'm trying to do a somewhat tricky mediation test. Basically, I'm looking at the relationship betwee…
Need some help dealing with duplicatesHi all, I need some help with dealing with duplicates in my data. I have something like this: va…
10000 posts by William LisowskiCongratulations William Lisowski on reaching the milestone of 10,000 posts on Statalist! Your contri…
Very large T- StatisticsHi Stata Community, I'm running some regressions using Fixed Effect Methodology. The issue is that t…
Subscribe to:
Post Comments (Atom)
0 Response to PSID - Generating a household ID
Post a Comment