i have question executing year() function in teradata sas. example, when executing code below, error message below codes. there way execute year() function besides using year function in sas after table created teradata?
select * connection teradata ( select customer_id , year(date) base.customers ); error: teradata execute: syntax error: expected between ',' , 'year' keyword
you getting error because there no year function in teradata. instead can use extract():
select * connection teradata ( select customer_id , extract(year date) base.customers ); 