ORA-00904: : invalid identifier.." occurs when you write a SAS® data set to an Oracle table

[alepage]

Hello,

I would like to know how to solve that issue:

https://support.sas.com/kb/16/850.html

ERROR: ORACLE execute error: ORA-00904: "PS"."RECORDID": invalid identifier.

[SASKiwi]

Google: "Oracle reserved words" and you will find this page: https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/Oracle-SQL-Reserved-Words.html

Check your SAS variable names against this list and rename any that are. Rerun your program to check if it fixes your problem.