Thank you. Could you please return in the form of a statement?
proc sql;
update WORK.FILE
set COLUMNB=intnx('month',input(cats('01-',date),anydtdte.),0,'end');
run;
DATA in its original format is in a column named COLUMNA. It could contain
any month or year, but we would like the last day in any given month
Stored Value in COLUMNA='APR-19'
New value produced in COLUMNB should be April, 30, 2019 in a sortable format.