The report uses default column headings (variable names) because neither
the SPLIT= nor the LABEL option is used. Nevertheless, the BY line at the
top of each section of the report shows the BY variables' labels and their
values. The BY variables' labels identifies the subtotals in the report summary
line.
PROC PRINT sums Price and Quantity for each BY group that contains more
than one observation. However, sums are shown only for the BY variables whose
values change from one BY group to the next. For example, in the first BY
group, where the sale type is Catalog Sale
and the sale date is 1/1/08, Quantity and Price
are summed only for the sale date because the next BY group is for the same
sale type.
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
|