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;
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!