PROC SQL: concatenate column with string

BrianConner — Thu, 22 Sep 2016 15:46:01 GMT

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

Re: PROC SQL: concatenate column with string

ballardw — Fri, 02 Jun 2017 12:49:44 GMT

Apparently your year variable is numeric.

Try

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

instead.

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