Automation is a commonly used word these days for companies who want to streamline their processes and for SAS ® programmers who want to make significant improvements in their programs to increase efficiency, and to make work and life simple. The SAS system provides us with powerful and handy tools for automation. It helps to avoid potential human errors, to cut down editing time, to guarantee accuracy and consistency, to provide fast turnaround time, to require less human intervention, and last but not least, it offers great opportunities to gain knowledge and experience to share with colleagues. This paper demonstrates one example using CALL SYMPUT, INTNX, and SAS macros to reduce manual steps so as to consolidate five to seven SAS programs into one SAS program. It simplifies the work process and life! BUSINESS BACKGROUND OF MY EXAMPLE This application reports members ’ additional dollar amounts in each month after their accumulated amount exceeded their group threshold limit. Each group renews their contracts annually, with a renewal date and threshold limit. Each report runs through 15 months, so a group could receive more than one report using both the current contract and previous year’s contract
To submit an update or takedown request for this paper, please submit an Update/Correction/Removal Request.