Please see the result which achieved by code: USA Road Bike Trek 5000 $2,200 USA Road Bike Cannondale 2000 $2,100 USA Mountain Bike Trek 6000 $1,200 USA Mountain Bike Cannondale 4000 $2,700 USA Hybrid Trek 4500 $650 France Road Bike Trek 3400 $2,500 France Road Bike Cannondale 900 $3,700 France Mountain Bike Trek 5600 $1,300 France Mountain Bike Cannondale 800 $1,899 France Hybrid Trek 1100 $540 United Kingdom Road Bike Trek 2444 $2,100 United Kingdom Road Bike Cannondale 1200 $2,123 United Kingdom Hybrid Trek 800 $490 United Kingdom Hybrid Cannondale 500 $880 United Kingdom Mountain Bike Trek 1211 $1,121 Italy Hybrid Trek 700 $690 Italy Road Bike Trek 4500 $2,890 Italy Mountain Bike Trek 3400 $1,877 proc print data = bicycles; var Country Model Units TotalSAles; by Model; sumby Model; run; The SAS System 00:49 Monday, January 12, 2009 33 -------------------------------------------- Model=Hybrid -------------------------------------------- Obs Country Model Units TotalSales 1 USA Hybrid 4500 $2,925 2 France Hybrid 1100 $594 3 United Kingdom Hybrid 800 $392 4 United Kingdom Hybrid 500 $440 5 Italy Hybrid 700 $483 ----- ----- ---------- Model 7600 $4,834 ---------------------------------------- Model=Mountain Bike ----------------------------------------- Obs Country Model Units TotalSales 6 USA Mountain Bike 6000 $7,200 7 USA Mountain Bike 4000 $10,800 8 France Mountain Bike 5600 $7,280 9 France Mountain Bike 800 $1,519 10 United Kingdom Mountain Bike 1211 $1,358 11 Italy Mountain Bike 3400 $6,382 ----- ----- ---------- Model 21011 $34,539 ------------------------------------------ Model=Road Bike ------------------------------------------- Obs Country Model Units TotalSales 12 USA Road Bike 5000 $11,000 13 USA Road Bike 2000 $4,200 14 France Road Bike 3400 $8,500 15 France Road Bike 900 $3,330 16 United Kingdom Road Bike 2444 $5,132 17 United Kingdom Road Bike 1200 $2,548 18 Italy Road Bike 4500 $13,005 ----- ----- ---------- Model 19444 $47,715 ===== ========== 48055 $87,088
... View more