Appending columns with the same table

[ismahero2]

Hi

I have a table with 2 columns and I want to create a column that contains everything present on those 2 columns.

Ex.  Append column 1 and Column 2 into Column 3.

Column 1	Column 2	Column 3
12	80	12
15	70	15
20	60	20
25	50	25
		80
		70
		60
		50

Any help with this...  I would like to do it in one single query and avoid creating 3 tables to do this.

Thank you

[Tom]

Seems like an extremely strange request.

data want ;

  set have (in=in1)

      have (keep=column2 rename=(column2=column3))

  ;

  if in1 then column3 = column1 ;

run;