topic Re: Combining columns in SAS Enterprise Guide

Combining columns

Visser — Tue, 26 Jul 2016 13:21:53 GMT

I want to combine the text of several columns into 1 computed column using SAS Query builder. I can't seem to figure it out 😞

Re: Combining columns

againreddy — Tue, 26 Jul 2016 15:32:39 GMT

on Query builder -> Click on "Computed column" -> Click on "New" -> Select "Advanced Expression" -> Type trim(column1)||trim(column2)||trim( column3)
-> click on "next" -> Enter new column name and click on "Finish"

Notes:
1. Column1 to 3 are your columns in your table
2.You can use trim/compress functions based on your choice.

Re: Combining columns

Visser — Tue, 26 Jul 2016 15:54:45 GMT

Thx! It worked!

Re: Combining columns

TomKari — Tue, 26 Jul 2016 16:23:32 GMT

There are also a number of cat... functions that are great for this kind of thing; cat, catq, cats,catt, catx.