Solved
Contributor
Posts: 28

# 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

 q1 q2a q2b q2c q2d q3 a e e a b b c a a b d d d c c

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

## Re: summarize character variables in a new variable

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

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

## Re: summarize character variables in a new variable

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.