Appending columns with the same table

ismahero2 — Mon, 02 Dec 2013 17:54:29 GMT

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.

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

Thank you

Re: Appending columns with the same table

Tom — Mon, 02 Dec 2013 18:32:42 GMT

Seems like an extremely strange request.

data want ;

set have (in=in1)

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

;

if in1 then column3 = column1 ;

run;