Hi All. Please kindly assist.
Below code:
proc sql; create table contract_file as select account_guid as 'CLIENT NUMBER'n, case when current_edc = "Blake" then "18811" when current_edc = "ARA" then "18810" else "18453" end as 'MERCHANT NUMBER'n label = 'MERCHANT NUMBER', case when pp_opening_invoice_age = "0" as 'CONTRACT NUMBER'n end as 'CONTRACT NUMBER'n, min(current_balance, installment) as 'AMOUNT'n, '1' as 'NUMBER OF INSTALLMENTS'n, 'ABSANAEDO' as 'PRODUCT CODE'n, 'O' as 'FREQUENCY'n, dhms(next_debit_order_date,0,0,0) as 'DATE'n format dtpic., '03' as 'TRACKING CODE'n, '' as 'ED / EOM'n
from BASE_file; quit;
I get the below error:
34 case when pp_opening_invoice_age = "0" as 'CONTRACT NUMBER'n __ 22 202 ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, -, /, <, <=, <>, =, >, >=, AND, EQ, EQT, GE, GET, GT, GTT, LE, LET, LT, LTT, NE, NET, NOT, OR, THEN, ^, ^=, |, ||, ~, ~=.
ERROR 202-322: The option or parameter is not recognized and will be ignored.
... View more