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
Melogit: variance of random slope looks insignficant, but LRtest says it is?Can someone please help me with a multilevel modeling question? I've gotten conflicting advice from …
Creating daily average and hourly levels from hourly dataHi everyone! I'm new to Stata and I would like to have some of your advice! I have gathered hourly…
How much computer specs do I have to analyze large data for fixed effectHi I have very large daily data. The number of rows is 1 million and the number of columns is 50. Ho…
hierarchical random effect meta-analysisHi everyone, I am doing a meta-analysis and I want to use hierarchical random effect meta-analysis.…
Generate a row rather than ColumnHello Everyone, May I ask if anyone has an idea if we can generate a row of data in stata? If I hav…
Subscribe to:
Post Comments (Atom)
0 Response to PSID - Generating a household ID
Post a Comment