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
Assigning Continuous number to year and monthsHi all, I have date like this: date jan2015 jan2015 feb2015 march2015 march 2015 march2015 I want…
merging different data with different countries and different yearsIs there a way to merge different datasets with different countries and different years, and then ch…
Weighted Tabulation by Multiple Groups -- Export to XLS or DTAHello, I am using YRBS data -- a student survey taken in each US state every other year. Each entry …
Question on Nick Cox's aaplotSorry for this post, but I have spent over an hour with the data and with the manual but I have a pr…
Modelling wind direction and fire spreadI'm interested in finding whether wind direction is a good predictor of the direction of fire spread…
Subscribe to:
Post Comments (Atom)
0 Response to PSID - Generating a household ID
Post a Comment