I have tried putting COLLECTION_ENTRY_DATE,monyy5.) and different variations but without success can you advice?
Full script is:
proc sql; create table enteredcollections as select SCHEMA, ACCOUNT_NO, SCENARIO_NAME, COLLECTION_ENTRY_DATE, input (COLLECTION_EXIT_DATE, monyy5.) as Entry_Month_Y, COLLECTION_EXIT_DATE, ENTRY_AMOUNT, EXIT_AMOUNT, REASON, case when reason = 0 and exit_amount = 0 then '1' else "" end as countentry from webapp.enteredcollections order by account_no ; quit;