Asked • 03/14/19

concat two numbers in sas proc sql?

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?

1 Expert Answer


Alexander D. answered • 03/15/19

5.0 (63)

Experienced Quantitative Analytics Specialist

Still looking for help? Get the right answer, fast.

Ask a question for free

Get a free answer to a quick problem.
Most questions answered within 4 hours.


Find an Online Tutor Now

Choose an expert and meet online. No packages or subscriptions, pay only for the time you need.