Using PROC SQL to Summarize and Transpose Data
Does one need to create a SAS data set using SUMMARY and TRANSPOSE procedures? Does one want to replace the SUMMARY and TRANSPOSE procedures with a SQL script which is easy to maintain and extend? If the answer is yes, then the PROC SQL tips provided in this paper would be very helpful to improve the data processing routine. This paper demonstrates how to use one single SQL CREATE TABLE statement to perform the count, summarize, and transpose data. The purpose of this paper is to provide an alternative way to manipulate data more efficiently than using traditional methods such as data step, SUMMARY and TRANSPOSE procedures.