Base SAS contains couple of very nice procedures to create reports on your data . This tips and tricks shows you an overview of the most popular including The Proc Tabulate which is one of the most powerful SAS reporting Procedure.

In this tips and tricks, we will first have a look to different reports that Base SAS offers:

• Proc Print,
• Proc means,
• Proc Freq,
• Proc Univariate,
• Proc Report.

In a second step, we will focus on the Proc Tabulate and see how this procedure generates multidimensional reports like Excel pivot tables :

• Class statement
• Var statement
• Table statement

Then we will see how we can influence the table statement in order to change the statistics, the labels, the format, the missing's values, add traffic light (etc.). We will also discuss the possibility to output results in tables and use options like ODS trace to select only part of reports...

You have some SAS experience and would like to use SAS procedures to create reports.