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!
Use the coalesce function.
abcd_question=coalesce(a_question,b_question,c_question,d_question);
Use the coalesce function.
abcd_question=coalesce(a_question,b_question,c_question,d_question);
That worked, thanks so much! I thought I had tried that before but I must have had a typo or some other syntax misstep.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.