ABSTRACT
AE tables are parts of clinical trial report on safety analysis. Generally, it is required to present both event numbers and subject numbers. To save time and improve the quality of deliverables, we created a SAS macro for company use. In this paper, we explore our macro and show readers how to use simple data step, SQL statements and array functions to get the event numbers and subject numbers.