Hello:

I am new to SPSS syntax and I've searched for the answer to my question in the manual but I can't seem to find the solution to my problem. If it is there I apologize.

I am performing a secondary analysis on a database I did not create and I wish to collapse eight variables into three. The eight variables represent different levels of education, so in EDU 1 through to EDU8, if a person attained that level of education there is a 1, otherwise there is a missing variable. It looks something like this:

EDU1 EDU2 EDU3