concat two numbers in sas proc sql?

Question

I have a table that has two numeric values called `year` and `month`. I would like to create a new table that has one value called `ym` which is just the concatenation of `year` and `month`. Here is an example: proc sql; create table test as select CONCAT(year, month) as ym from tbl; run; What is the `CONCAT` function that goes there?

Answer 1

you can use sas function within sql statements. My preferred is catx. The first argument is the delimiter used between fields passed, so for the below the delimiter is nothing.

proc sql;

create table test as select catx('', year,month) as ym from tbl;

quit;