Hi, I m trying to concatenate few strings so that the output looks like following.  ACT_D:20230402 The syntax I was using is 'ACT_D:'||PUT(Complete_Full_Date, yymmddn8.) as REF4, but it gives the error as  ERROR 22-322: Syntax error, expecting one of the following: (, ). ERROR 76-322: Syntax error, statement will be ignored.     The complete code is as following:  proc sql; create table FORMATED_COMP AS SELECT Order_Number AS Invoice, &Paydate as Pay_Date , EMPLOYEE_PEIN as Employee , 1 as Item , 'COSBI' as REASON_CODE , Channel_Level_2 as LC, ISSUED_FULL_DATE AS SALE_DATE format date9., '' as ESN , '' AS TEXT1 , '' AS TEXT2 , '' AS POSSKU , 'LOB:DSL' AS REF1 , Product_Description AS REF2, CASE WHEN PRODUCT_CODE IN ( '1-3K1XCP0', '1-3K1XCOB', '1-J6FZOO-C17', '1-J6G02L-C17', '1-J6HCI9-C17', '1-J6HCI9-C17LOB', '1-J6HCKD-C17', '1-J6FZWE-C17') THEN 'Internet 5, 5 Plus or' ELSE 'Internet 100+' END as REF3, 'ACT_D:'||PUT(Complete_Full_Date, yymmddn8.) as REF4, 'BRS Base Commission' as REF5 , '' as REF6, '' as REF7, '' as REF8, 1 AS Volume , '' as Base_package_Price , Commission AS Amount, '' as Amount2 , Dealer_NM AS Corp_store_name, Province_Code as Region_Name, '' as Employee_Name , 'SB Internet Commission' as DESCRIPTION, EMP_TITLE_EN_DESC AS JOB_NAME, case when EMP_TITLE_EN_DESC = 'Sales Consultant - BRS Retail' then 'SP' else 'NSP' end as JGRP, COMPLETE_FULL_DATE AS Activation_Dt format date9. '' as Paid_sts, '' as Status FROM Employee_info t1 ; RUN;   Will appreciate the help. Thanks .   I am using SAS EG.    ... View more