Russ Lavery
PROC Report is a powerful big data tool because PROC Report reads the source data set only one time and performs all other calculations on a hidden internal file- greatly reducing run time. If the data being fed into PROC Report is in the proper structure, using PROC Report can save run time as well as hundreds of lines of SAS code.
PROC Report combines the convenience of a Proc Print with the power of the Data Step and can produce complete, complex and colorfully traffic-lighted reports in one procedure call. This mini-seminar concentrates on the internal processes of product report – how calculations are done. Understanding internal processes are required in order to calculate nested percentages and totals that are often required for complicated reports. Creating colorful and highly nested reports, using PROC Report, has been covered in many SUG papers but this topic, calculations, has not.
This talk (slides and an accompanying audio) was burned onto a CD and was glued onto the back cover of Art Carpenter’s excellent book on PROC Report. If you have a hard-cover copy of that book, you already have this mini-seminar. Since that book is now being sold as a soft cover, The CD can no longer be purchased but the talk can now be presented at SUGs.
View paper.