Select the observations to process. The WHERE statement selects for the report only
the observations for stores in the northeast and northwest sectors. The TITLE statement
specifies the title.
where sector contains 'n';
Specify the title.
title 'Sales Figures for Northern Sectors';
run;
Output: HTML
Output 51.5Consolidating Multiple Observations into One Row of a Report
Example 6: Creating a Column for Each Value of a Variable
Features:PROC REPORT statement options
SPLIT=
COLUMN statement
stacking variables
DEFINE statement options
GROUP
ACROSS
ANALYSIS
COMPUTED
SUM
FORMAT=
COMPUTE statement arguments
with a computed variable as report-item
Example 6: Creating ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.