Hi!
I am researching the effect of cosmetic combinations on the perception of leadership characteristics. I collected data on 24 images: 6 treatment versions of 4 images. The data that I collected consists of ratings of each photo on 6 leadership characteristics, hence 6 dependent variables. I, therefore, collected 24x6=144 rating values, each rating being given by approximately 25 respondents. The 6 treatment versions consist of 2 independent variables: brow enhancement (yes or no) and lipstick colour (none, pink, red).

Since I basically collected 144 ratings, Stata has imported the data as 144 variables.

How can I transform the data such that I obtain 6 dependent variables and 2 independent variables from the 144 var's?

I think the problem with my data currently is that the variables pertain to the images rather than to the subject, which would be the case for e.g. control variables like gender, age etc.

Rather than having the current variables in Stata listed as separate variables, I need to ensure that I group the data such that I obtain:

Dependent variables:
Intelligence
Dominance
Honesty&integrity
Self-confidence
Leadership effectiveness
Attractiveness

Independent variables:
Brows
Lipstick colour

NB: the data from the four images can be aggregated.


Hope someone can help!