Hi , I have a date stored in a macro variable (RUN_DATE) which is resolving to 06NOV2019. I want to store this value in a oracle table with number format like 20191106. In SAS DI studio I tried using input(&RUN_DATE,DATE9.) in the expression column and in format I selected yymmdd10. But its giving error 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, ^, ^=, |, ||, ~, ~=. Line 3,986: ERROR 76-322: Syntax error, statement will be ignored. Please help.
... View more
