I need to return an existing date from a column or for it to assign a specific date "12-31-2016" but I am getting the following error:
4 PROC SQL NOEXEC; 5 SELECT (ifn(t1.consolidated is not missing, t1.consolidated, "12-31-2016")) AS CALCULATION 6 FROM WORK.QUERY_FOR_MERGEDFINALANDANCHORDA t1; ERROR: Function IFN requires a numeric expression as argument 3.