Syntax error is back in my code.... not sure where is the error...   , case 125 when clm.item_number in (&Fittings) 126 and clm.item_number not in (631,636,641,651,656,661,761,771,821,826,831) 127 and 128 ( 129 (cast(clm.Claim_Date_Of_Service as date) - cast(clm.Left_Fitting_Date as date) < 7 __ __ 22 22 202 202 ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, ), *, **, +, ',', -, /, <, <=, <>, =, >, >=, ?, AND, BETWEEN, CONTAINS, EQ, EQT, GE, GET, GT, GTT, IN, IS, LE, LET, LIKE, LT, LTT, NE, NET, NOT, NOTIN, OR, ^, ^=, |, ||, ~, ~=. ERROR 202-322: The option or parameter is not recognized and will be ignored. 130 and ) _ 22 200 ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, a numeric constant, a datetime constant, a missing value, (, +, -, BTRIM, CALCULATED, CASE, EXISTS, INPUT, NOT, PUT, SUBSTRING, TRANSLATE, USER, ^, ~. ERROR 200-322: The symbol is not recognized and will be ignored. 131 cast(clm.Claim_Date_Of_Service as date) - cast(clm.Left_Fitting_Date as date) >= 0) __ __ 22 22 202 202 ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, ), *, **, +, ',', -, /, <, <=, <>, =, >, >=, ?, AND, BETWEEN, CONTAINS, EQ, EQT, GE, GET, GT, GTT, IN, IS, LE, LET, LIKE, LT, LTT, NE, NET, NOT, NOTIN, OR, ^, ^=, |, ||, ~, ~=. ERROR 202-322: The option or parameter is not recognized and will be ignored. 132 or 133 (cast(clm.Claim_Date_Of_Service as date) - cast(clm.Right_Fitting_Date as date) < 7 __ __ 22 22 202 202 ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, ), *, **, +, ',', -, /, <, <=, <>, =, >, >=, ?, AND, BETWEEN, CONTAINS, EQ, EQT, GE, GET, GT, GTT, IN, IS, LE, LET, LIKE, LT, LTT, NE, NET, NOT, NOTIN, OR, ^, ^=, |, ||, ~, ~=. ERROR 202-322: The option or parameter is not recognized and will be ignored. 134 and ) _ 22 200 4 The SAS System 22:24 Monday, November 28, 2022 ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, a numeric constant, a datetime constant, a missing value, (, +, -, BTRIM, CALCULATED, CASE, EXISTS, INPUT, NOT, PUT, SUBSTRING, TRANSLATE, USER, ^, ~. ERROR 200-322: The symbol is not recognized and will be ignored. 135 cast(clm.Claim_Date_Of_Service as date) - cast(clm.Right_Fitting_Date as date) >= 0) __ __ 22 22 202 202 ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, ), *, **, +, ',', -, /, <, <=, <>, =, >, >=, ?, AND, BETWEEN, CONTAINS, EQ, EQT, GE, GET, GT, GTT, IN, IS, LE, LET, LIKE, LT, LTT, NE, NET, NOT, NOTIN, OR, ^, ^=, |, ||, ~, ~=. ERROR 202-322: The option or parameter is not recognized and will be ignored. 136 ) 137 then 'Y' 138 else 139 '' 140 end as DOSlt7DOF ... View more

Sorry, I've managed to fix the previous error.  Now I got this;   from hsoprd.claim /*as clm*/ 192 193 /* inner join hsoprd.provider as prv 194 on clm.service_provider_id = prv.service_provider_id*/ 195 inner join hsoprd.voucher as vch 196 on clm.voucher_id = vch.voucher_id 197 /* inner join hsoprd.client as clt 198 on clm.client_detail_id = clt.client_detail_id*/ 199 /* inner join hsoprd.site as site 200 on clm.site_detail_id = site.site_detail_id*/ 201 /* inner join hsoprd.practitioner as prc 202 on clm.practitioner_detail_id = prc.practitioner_detail_id*/ 203 left join hsoprd.device as ldvc 204 on clm.left_device_id = ldvc.device_id 205 left join hsoprd.device as rdvc 206 on clm.right_device_id = rdvc.device_id 207 208 where clm.claim_detail_status = 'Approved' 209 /* and clm.date_of_payment >= &tdSDate 210 and clm.date_of_payment < &tdEdate*/ 211 order by clm.claim_date_of_service 212 ; ERROR: File WORK.HSOPRD_CLAIM_ITEM.DATA does not exist. NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. 213 /*disconnect from teradata;*/ 214 quit;   Thanks ... View more