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!
No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.
Your password has been sent to:firstname.lastname@example.org
To follow this tag...
Thanks! We'll email you when relevant content is added and updated.
Share this item with your network: