combine variables across observations

[sydneyb]

Hi all, I am trying to combine variables across multiple observations. I have four different surveys that all ask the same questions on a likert scale and I would like to combine the answers into one variable.

My data looks like this:

ID     a_question       b_question      c_question       d_question

1             1

2                                      2

3                                                                3

4                                                                                     4

5             1

6                                        2

I would like my dataset to look like this:

ID                    abcd_question

1                               1

2                               2

3                               3

4                               4

5                               1

6                               2

Thanks for any insight!

[ChrisNZ · Accepted solution]

Use the coalesce function.

abcd_question=coalesce(a_question,b_question,c_question,d_question);

[sydneyb]

That worked, thanks so much! I thought I had tried that before but I must have had a typo or some other syntax misstep.