Transforming table

[Betty_sam]

Hi, 

I have data like this : 

Full_name	Q1	Q2	Q3
A	1	-	-
B	-	2	-
C	-	-	3

I want to transform it into 

Full_name	Q
A	1
B	2
C	3

How can I do this please ? 

Thank you

[Sajid01]

One way of doing this is as follows.
You can modify as needed.

data test;
input full_name $ Q1 Q2 Q3;
datalines;
A 1 . .
B . 2 .
C . . 3
;
run;
data test( drop=q1 q2 q3);
set test;
Q=sum(q1,q2,q3);
run;

[Reeza · Accepted solution]

COALESCE()

Q = coalesce(of Q1-Q3);