Please help to resolve the warning message. We recieve this warning only after SAS 9.4 Upgrade, earlier SAS (R) 9.1 (TS1M3) never reported this kind of warning. Please advice. WARNING: Character expression will be truncated when assigned to character column CAC. NOTE: Statement transforms to: insert into WORK.ACCUM(ACCUM.YEAR, ACCUM.MONTH, ACCUM.REGION, ACCUM.CAC, ACCUM.BENCAT, ACCUM.UWNONUW, ACCUM.AMT) select A.YEAR, A.MONTH, A.REGION, A.CAC, 'T', COALESCE(B.UWNONUW, 'U'), A.GLAMT from WORK.HSCIIIW1 A left outer join WORK.HSCIIT46 B on A.ACCOUNT = B.ACCOUNT where A.ACCOUNT like '5%' and A.ACCOUNT not in ( select HSCIIT46.ACCOUNT from WORK.HSCIIT46 where HSCIIT46.FLAG1 = 'X' ) and (A.YEAR = 2014) and (A.MONTH = 10); NOTE: 5 rows were inserted into WORK.ACCUM.
... View more