Desktop productivity for business analysts and programmers

Concatenate Problem

Reply
N/A
Posts: 0

Concatenate Problem

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
Contributor
Posts: 50

Re: Concatenate Problem

Hi Brad,

If i understood maybe this helps you.

data test;
year=2002;
qtr=4;
year_qtr=catx(' - ', year, qtr);
run;
N/A
Posts: 0

Re: Concatenate Problem

That worked thanks!
Ask a Question
Discussion stats
  • 2 replies
  • 113 views
  • 0 likes
  • 2 in conversation