Hi family,
I have a data set that the individual household member's information is presented in the wide format instead of the expected long format(row per every household member with repeated hhID if same household).
I tried my best by using the command reshape wide mid1, i(otherhh_id) j(hhnumber) but it didn't work out.
Any help?.
I attached the dataset for your perusal.
Thank you.
Sham
Related Posts with How to reshape/convert a household data set in the wide format to long format
Threshold for small/large T in quarterly panel dataDear all, Sorry for basic question. I am estimating dynamic panel data model for 40 countries &…
Count and recordHi all, My data has four variables: acty, deady, nation, and id. "acty" is the year when company is…
Creating a variable equal to 1 if a name (i.e., string) at time t-4 appears at time tI have Brazilian electoral data with the names of candidates who ran for mayor from 2000 to 2016. Th…
Coding a new variable: where a category selects 'high' responses for one variable only if there are low responses for another variableHi Statalist. I want to code 'impat' with three categories (1 = both low, 2 = one high, 3 = both hi…
Finding duplicate variablesDear Statalisters, I am writing you because I would like to find out if I have duplicate variables …
Subscribe to:
Post Comments (Atom)
0 Response to How to reshape/convert a household data set in the wide format to long format
Post a Comment