Does anyone of you know an easy and fast way to deal with the
following data structure:
- I have a large survey data set containing data on individuals
(unique records per individual over the complete data set)
- the survey is/was carried out each year
- within every year, there are variables like trust_1, trust_2,
trust_3 trust_4, each for a specific issue addressed
- I would like to have a data set with the individual data (basic
characteristics) plus one variable "trust"; e.g. if individual A has
entries in trust_1, trust_2 and trust_3, I would like to have three
entries for individual A containing the basic characteristics and each
of the trust variables named as trust, so that in the end I could
regress on trust!