pick up variables in one column

[Barney1998]

Hallo to everyone.

I have this problem. I have a big data set so this i will try to explain you it was difficult to be implemented by hand.

First of all i have one data set which looks like:

qq1 qq2 qq3 qq4
1                              
          0     

          0 
                 2          
                       11
i want to pick up all the variables in one new column 
like
qq
1
0
0
2
11

from the first table if one column value is not missing means that all the other columns are missing in the same row
thank you in advance

[FreelanceReinh]

Hallo @Barney1998,

If qq1 - qq4 are numeric variables, you can use the COALESCE function to obtain the first non-missing value:

data have;
input qq1-qq4;
cards;
1 . . .
. 0 . .
. 0 . .
. . 2 .
. . . 11
;

data want(drop=qq1-qq4);
set have;
qq=coalesce(of qq1-qq4);
run;

For character variables there is the similar COALESCEC function.