summarize character variables in a new variable

Accepted Solution Solved
Reply
Contributor
Posts: 28
Accepted Solution

summarize character variables in a new variable

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

q1q2aq2bq2cq2dq3
aee
abb
caa
bdd
dcc

Accepted Solutions
Solution
‎09-11-2012 04:45 AM
Super Contributor
Posts: 349

Re: summarize character variables in a new variable

Posted in reply to loedrup_ab

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

View solution in original post


All Replies
Solution
‎09-11-2012 04:45 AM
Super Contributor
Posts: 349

Re: summarize character variables in a new variable

Posted in reply to loedrup_ab

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

Contributor
Posts: 28

Re: summarize character variables in a new variable

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

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 218 views
  • 4 likes
  • 2 in conversation