PROC SQL: concatenate column with string

[BrianConner]

Hi All,

Below I am trying to concatenate the string 'Prospective Targeted' with field INT_YEAR. When I run the program I get error '

ERROR: Concatenation (||) requires character operands.'

SELECT

MEMBER_HCID

,MAX(CASE WHEN T2.HC_ID IS NOT NULL THEN 'Prospective Targeted'||''|| INT_YEAR ELSE 'NOT TARGETED' END) AS Prospective_Target

[ballardw · Accepted solution]

Apparently your year variable is numeric.

Try

  catx(' ','Prospective Targeted',INT_YEAR )

instead.

The concatenation functions generally have better behavior than || concatenation operator.