Dear anyone
Given the single choice answer in q1 (a-d) repondents get to answer q2a - q2d,(single choice, a - e) as shown in excel below. How can I summarize q2a - q2d in q3 as shown in excel below?
Hope to hear from you
sincerely Anders
q1 | q2a | q2b | q2c | q2d | q3 |
a | e | e | |||
a | b | b | |||
c | a | a | |||
b | d | d | |||
d | c | c |
Hi,
Is this what you are looking for? or i have not understand your requirement.
data have;
infile cards dsd dlm=',';
input q1 $ q2a $ q2b $ q2c $ q2d $;
q3=COALESCEC(q2a,q2b,q2c,q2d);
cards;
a,e,,,
a,b,,,
c,,,a,
b,,d,,
d,,,,c
;
run;
Thanks,
Shiva
Hi,
Is this what you are looking for? or i have not understand your requirement.
data have;
infile cards dsd dlm=',';
input q1 $ q2a $ q2b $ q2c $ q2d $;
q3=COALESCEC(q2a,q2b,q2c,q2d);
cards;
a,e,,,
a,b,,,
c,,,a,
b,,d,,
d,,,,c
;
run;
Thanks,
Shiva
Hi Shiva
Super. The COALESCEC(q2a,q2b,q2c,q2d) did the trick
I just did (data 'have' contains the values of q1 and q2a - q2d):
data want; set have;
q3=COALESCEC(q2a,q2b,q2c,q2d);
run;
Thank you for helping out.
cheers Anders
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.