| Procedure features: |
|
PROC PRINT statement options:
|
|
BY statement |
|
SUM
statement |
|
| Other features: |
|
ODS HTML statement |
|
LABEL statement |
|
FORMAT statement |
|
SORT procedure |
|
TITLE
statement |
|
| Data set: |
EXPREV
|
This example demonstrates the following
tasks:
-
sums quantities and retail prices for the following items:
-
shows the number of observations in each BY group and in the whole
report
-
displays the BY group label in place of the BY group variable
name on the summary line
-
creates a default HTML report
-
creates a stylized HTML report
 |
options nodate pageno=1 linesize=80 pagesize=40; |
| |
proc sort data=exprev;
by sale_type order_date;
run; |
| |
proc print data=exprev n noobs sumlabel; |
| |
by sale_type order_date;
sum price quantity; |
| |
label sale_type='Sale Type'
order_date='Sale Date';
format price dollar10.2 cost dollar10.2;
title 'Retail and Quantity Totals for Each Sale Date and Sale Type';
run; |
Summing Numeric Variables with Multiple BY Variables: Listing Output
| |
Retail and Quantity Totals for Each Sale Date and Sale Type 1
---------------------- Sale Type=Catalog Sale Date=1/1/08 ----------------------
Ship_
Country Emp_ID Date Quantity Price Cost
Puerto Rico 99999999 1/5/08 14 $51.20 $12.10
Aruba 99999999 1/4/08 30 $123.70 $59.00
Bahamas 99999999 1/4/08 8 $113.40 $28.45
Bermuda 99999999 1/4/08 7 $41.00 $9.25
----------- -------- ----------
Sale Date 59 $329.30
N = 4
---------------------- Sale Type=Catalog Sale Date=1/2/08 ----------------------
Ship_
Country Emp_ID Date Quantity Price Cost
British Virgin Islands 99999999 1/5/08 11 $40.20 $20.20
Canada 99999999 1/5/08 100 $11.80 $5.00
El Salvador 99999999 1/6/08 21 $266.40 $66.70
Brazil 120127 1/2/08 12 $73.40 $18.45
French Guiana 120935 1/2/08 15 $96.40 $43.85
Grenada 120931 1/2/08 19 $56.30 $25.05
Paraguay 120603 1/2/08 17 $117.60 $58.90
Peru 120845 1/2/08 12 $93.80 $41.75
---------------------- -------- ----------
Sale Date 207 $755.90
Sale Type 266 $1,085.20
N = 8 Retail and Quantity Totals for Each Sale Date and Sale Type 2
--------------------- Sale Type=In Store Sale Date=1/1/08 ----------------------
Ship_
Country Emp_ID Date Quantity Price Cost
Virgin Islands (U.S.) 99999999 1/4/08 25 $31.10 $15.65
N = 1
--------------------- Sale Type=In Store Sale Date=1/2/08 ----------------------
Ship_
Country Emp_ID Date Quantity Price Cost
Belize 120458 1/2/08 2 $146.40 $36.70
Cayman Islands 120454 1/2/08 20 $71.00 $32.30
Guatemala 120931 1/2/08 13 $144.40 $65.70
Jamaica 99999999 1/4/08 23 $169.80 $38.70
Mexico 120127 1/2/08 30 $211.80 $33.65
Montserrat 120127 1/2/08 19 $184.20 $36.90
Anguilla 99999999 1/6/08 15 $233.50 $22.25
Antigua/Barbuda 120458 1/2/08 31 $99.60 $45.35
Argentina 99999999 1/6/08 42 $408.80 $87.15
Barbados 99999999 1/6/08 26 $94.80 $42.60
Bolivia 120127 1/2/08 26 $66.00 $16.60
Chile 120447 1/2/08 20 $19.10 $8.75
Ecuador 121042 1/2/08 11 $100.90 $50.55
Falkland Islands 120932 1/2/08 15 $61.40 $30.80
Guyana 120455 1/2/08 25 $132.80 $30.25
Martinique 120841 1/3/08 16 $56.30 $31.05
Netherlands Antilles 99999999 1/6/08 31 $41.80 $19.45
-------------------- -------- ----------
Sale Date 365 $2,242.60
Sale Type 390 $2,273.70
N = 17 Retail and Quantity Totals for Each Sale Date and Sale Type 3
--------------------- Sale Type=Internet Sale Date=1/1/08 ----------------------
Ship_
Country Emp_ID Date Quantity Price Cost
Antarctica 99999999 1/7/08 2 $92.60 $20.70
N = 1
--------------------- Sale Type=Internet Sale Date=1/2/08 ----------------------
Ship_
Country Emp_ID Date Quantity Price Cost
Costa Rica 99999999 1/6/08 31 $53.00 $26.60
Cuba 121044 1/2/08 12 $42.40 $19.35
Dominican Republic 121040 1/2/08 13 $48.00 $23.95
Haiti 121059 1/2/08 5 $47.90 $23.45
Honduras 120455 1/2/08 20 $66.40 $30.25
Nicaragua 120932 1/2/08 16 $122.00 $28.75
Panama 99999999 1/6/08 20 $88.20 $38.40
Saint Kitts/Nevis 99999999 1/6/08 20 $41.40 $18.00
St. Helena 120360 1/2/08 19 $94.70 $47.45
St. Pierre/Miquelon 120842 1/16/08 16 $103.80 $47.25
Turks/Caicos Islands 120372 1/2/08 10 $57.70 $28.95
United States 120372 1/2/08 20 $88.20 $38.40
Colombia 121059 1/2/08 28 $361.40 $90.45
Dominica 121043 1/2/08 35 $121.30 $57.80
Guadeloupe 120445 1/2/08 21 $231.60 $48.70
St. Lucia 120845 1/2/08 19 $64.30 $28.65
-------------------- -------- ----------
Sale Date 305 $1,632.30
N = 16 Retail and Quantity Totals for Each Sale Date and Sale Type 4
--------------------- Sale Type=Internet Sale Date=1/3/08 ----------------------
Ship_
Country Emp_ID Date Quantity Price Cost
Suriname 120538 1/3/08 22 $110.80 $29.35
--------- -------- ----------
Sale Type 329 $1,835.70
======== ==========
985 $5,194.60
N = 1
Total N = 48
| |
options nodate pageno=1 linesize=80 pagesize=40 obs=10;
| |
ods html file='your_file.html'; |
proc sort data=exprev;
by sale_type order_date;
run;
proc print data=exprev n noobs sumlabel;
by sale_type order_date;
sum price quantity;
label sale_type='Sale Type' order_date='Sale Date';
format price dollar10.2 cost dollar10.2;
title 'Retail and Quantity Totals for Each Sale Date and Sale Type';
run;
| |
ods html close; |
The following three displays comprise the output that creates default
HTML output.
Summing Numeric Variables with Multiple BY Variables: Catalog Sales: Default HTML Output
![[Summing Numeric Variables with Multiple BY Variables: Catalog Sales: Default HTML Output]](images/proc-print-ex5-html-1.gif)
Summing Numeric Variables with Multiple BY Variables: In Store Sales: Default HTML Output
![[Summing Numeric Variables with Multiple BY Variables: In Store Sales: Default HTML Output]](images/proc-print-ex5-html-2.gif)
Summing Numeric Variables with Multiple BY Variables: Internet Sales: Default HTML Output
![[Summing Numeric Variables with Multiple BY Variables: Internet Sales: Default HTML Output]](images/proc-print-ex5-html-3.gif)
options nodate pageno=1 linesize=80 pagesize=40 obs=10
ods html file='your_file.html';
proc sort data=exprev;
by sale_type order_date;
run;
proc print data=exprev n noobs sumlabel;
| |
by sale_type order_date;
sum price / style(GRANDTOTAL) = [background =white color=blue];
sum quantity / style(TOTAL) = [background =dark blue color=white]; |
label sale_type='Sale Type' order_date='Sale Date';
format price dollar10.2 cost dollar10.2;
title 'Retail and Quantity Totals for Each Sale Date and Sale Type';
run;
ods html close;
The following three displays comprise the output that creates styles
in the HTML output.
Summing Numeric Variables with Multiple BY Variables: Catalog Sales: HTML Output Using Styles
![[Summing Numeric Variables with Multiple BY Variables: Catalog Sales: HTML Output Using Styles]](images/proc-print-ex5-htmlstyle-1.gif)
Summing Numeric Variables with Multiple BY Variables: In Store Sales: HTML Output Using Styles
![[Summing Numeric Variables with Multiple BY Variables: In Store Sales: HTML Output Using Styles]](images/proc-print-ex5-htmlstyle-2.gif)
Summing Numeric Variables with Multiple BY Variables: Internet Sales: HTML Output Using Styles
![[Summing Numeric Variables with Multiple BY Variables: Internet Sales: HTML Output Using Styles]](images/proc-print-ex5-htmlstyle-3.gif)
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.
