Several possibilities exist for creating summary data sets and summary reports. PROC SQL is one choice; PROC MEANS, PROC TABULATE, and PROC REPORT all have methods to produce summary reports and summary data sets. Each procedure has its own syntax...for example, PROC SQL has the CREATE TABLE statement; PROC MEANS has the OUTPUT statement; PROC TABULATE and PROC REPORT both have the OUT= option, as well as an ODS OUTPUT possibility for most of the above procedures.
There have been previous forum posts on the subject of summary reports and summary tables/datasets. In addiiton, the documentation on each of the procedures is quite thorough. If you can't find an example in the documentation that suits your needs, you might wish to contact Tech Support for more help.