topic Concatenate Problem in SAS Enterprise Guide

Concatenate Problem

deleted_user — Thu, 30 Oct 2008 19:28:03 GMT

I'm having a hard time concatenating values in two different columns into one column. I have column YEAR and column QTR and I want a column YEAR_QTR that separates the year and the qtr by a hyphen "-".

YEAR = 2002
QTR = 4
YEAR_QTR = 2002 - 4

Thanks,
Brad

Re: Concatenate Problem

BrunoSilva — Thu, 30 Oct 2008 20:46:12 GMT

Hi Brad,

If i understood maybe this helps you.

data test;
year=2002;
qtr=4;
year_qtr=catx(' - ', year, qtr);
run;

Re: Concatenate Problem

deleted_user — Fri, 31 Oct 2008 13:14:21 GMT

That worked thanks!