Sentry Page Protection

Please Wait...

Data for Coding Exercises

---

The next four exercises will be based on the WALMART and AMAZON tables below.

Copy and run the code from the yellow box.

data walmart; infile datalines dlm="~"; input product : $200. weight : $20. description : $500. price ; datalines; Aluminum Foil~75 sq ft~Boulder~1.99 Apple Juice~64 fl oz~Nature's Nectar~1.69 Apple Sauce~25 oz~Sweet Harvest, regular or cinnamon~1.29 Apples, Gala, bag~3 lbs~Washington apples, various growers~2.99 Apples, Red/Golden Delicious (and/or other), bag~3 lbs~Washington apples, various growers, Red Delicious, Golden Delicious, Fuji, Granny Smith~3.29 Bacon~16 oz~Appleton Farms~2.99 Bagles, plain~20 oz~L'oven Fresh, 6 ct~1.49 Barbeque Sauce~18 oz~Burman's, original, hickory or honey~0.89 Beef Stew Meat~per lb~Cattlemen's Ranch, packaged at about 1.5 lbs~4.19 Beer, bottle, pilsener, import~6 pack~Wernesgrüner, Germany, 6 x 12 oz~5.99 Brats, 4-6 pack~14 oz~Parkview, 6 brats, smoked, cheddar or stadium style~1.99 Bread Crumbs~15 oz~Chef's Cupboard~0.89 Bread, 12-grain/multi-grain~24 oz~L'oven Fresh~1.89 Breakfast Sausage, frozen~7 oz~Breakfast Best, 10 links~0.89 Butter, real, unsalted/salted~1 lb~Countyside Creamery~2.29 Carrots, whole~2 lbs~Freshire Farms~1.29 Cheery Pie Filling~21 oz~Baker's Corner~1.79 Cheese Singles (imitation)~10.67 oz~Lynder, 16 slices~0.99 Cheese, Brie 1~6 oz~President, brie log ("Aldi special buy")~2.99 Cheese, Parmesan, jar~8 oz~Reggano, 100% real grated~2.39 Cheese, block (regular)~8 oz~Happy Farms, assorted varieties~1.99 Cheese, shredded, Mexican style~12 oz~Happy Farms~2.79 Cheese, shredded, Mozarella~16 oz~Happy Farms~2.99 Cheese, sliced, regular~8 oz~Happy Farms, 10 slices~1.99 Chicken Breasts, frozen~3 lbs~Kirkwood~5.49 Chicken Nuggets, frozen~32 oz~Kirkwood~3.99 Chicken Tenderloins, frozen~2.5 lbs~Kirkwood~5.99 Chips, potato chips~11 oz~Clancy's, assorted~1.49 Chocolate Chip Cookie Dough~16 oz~Buehler's, makes 24 cookies~1.99 Cocoa Rice Cereal~11 oz~Millville~1.69 Coffee~17.6 oz~Grandessa, German Roasted, mild or regular~4.99 Cold Cuts, ham or chicken~1 lb~Lunch Mate, ham, chicken or turkey~3.29 Corn Flakes, regular~18 oz~Millville~1.69 Corn Flakes, sugar frosted~17 oz~Millville~1.79 Cottage Cheese~24 oz~Friendly Farms, regular or low fat~1.99 Cream Cheese~8 oz~Happy Farms (regular), Fit & Active (low fat, Neufchatel)~1.19 Croissants~10 oz~L'oven Fresh, ~2.49 Eggs, regular~dozen~Goldhen, grade A large, white~1.09 Fish 1, frozen (flounder)~16 oz~Sea Queen, 4 fillets (wild caught)~3.99 Fish 2, frozen (tilapia)~24 oz~Tilapia, Sea Queen, 6 fillets~4.49 Fish 3, frozen~24 oz~Mahi Mahi, Sea Queen, 4 fillets (wild caught)~3.99 Flour, all purpose~5 lbs~Baker's Corner, enriched and bleached~1.59 Flour, self rising~5 lbs~Baker's Corner, enriched and bleached~1.59 French Fries, frozen~32 oz~Season's Choice~1.89 Fruit 1, frozen (strawberries)~16 oz~Season's Choice, strawberry or mixed fruit~1.99 Fruit 2, frozen~16 oz~Season's Choice, raspberries or "Triple Berry Blend"~2.99 Granola Bars, high fiber~7 oz~Millville, 6 bars, chocolate or peanut butter~1.89 Granola Bars, regular~8.4 oz~Millville, 10 bars, assorted flavors~1.59 Grapes, red~2 lbs~King Fresh, Produce Kountry and other growers, seedless~2.99 Green Beans, canned~14.5 oz~Happy Harvest, French style or cut~0.59 Ground Beef (chuck, 80/20)~per lb~All natural~2.89 Ground Beef (sirloin, 90/10)~per lb~All natural~3.49 Ground Beef, frozen~1 lb~No name, 85%, all natural~2.79 Ground Turkey~19.2 oz~Fit & Active, Prestage Farms~2.99 Ground Turkey, frozen~1 lb~Kirkwood~1.69 Ham, boneless~per lb~Appleton, sliced, packaged at 2 lbs, 1/4 ham~2.99 Honey~24 oz~Berry Hill, clover honey, all natural, 100% pure~4.49 Honey Crunch Oats~16 oz~Millville~1.89 Hot Dog Buns~12 oz~L'oven Fresh, 8 ct~0.99 Hot Dogs, beef~16 oz~Parkview, 8 ct~2.29 Ice Cream, premium~1.75 qt~Belmont, assorted flavors~2.49 Ice Cream, simple~0.5 gal~Sundae Shoppe, assorted flavors~1.99 Jalopeño Peppers, canned~12 fl oz~Tuscan Garden, rings, hotor mild~1.19 Ketchup~40 oz~Burman's~1.49 Kielbasa~16 oz~Parkview~1.99 Lemons~2 lbs~Various growers~1.99 Lettuce, iceberg~head~Capurro and other growers~0.99 Mandarin Oranges, canned~11 oz~Sweet Harvest~0.49 Margarine/Spread~16 oz~Countyside Creamery ("Tastes Like Butter")~0.99 Mayonnaise~30 fl oz~Burman's~2.19 Milk~1 gal~Friendly Farms, whole, 2% or non fat~1.99 Milk Chocolate Bar~5.29 oz~Choceur, Austrian~1.49 Mushrooms, Button, whole~8 oz~Freshire Farms~0.99 Mushrooms, stems/pieces~4 oz~Happy Harvest~0.59 Mustard, dijon~12 oz~Burman's~0.99 Mustard, yellow~14 oz~Burman's~0.69 Oat Meal~15.1 oz~Millville, 10 packets, maple & brown sugar, also as variety pack~1.49 Oil, Canola, 100% pure~48 fl oz~Carlini~2.69 Oil, Olive, 100% pure~16.9 fl oz~Carlini~2.99 Oil, Olive, extra virgin~16.9 fl oz~Carlini~3.49 Onions, yellow~3 lbs~Various growers~1.69 Orange Juice, not from concentrate~2 qt~Nature's Nectar~2.39 Oranges~4 lbs~Various growers, navel~2.99 Paper Towles~8 rolls~Boulder, 2-ply, 416 sheets total~5.99 Pasta, Egg Noodles~12 oz~Reggano~0.99 Pasta, Ellbow Maccaroni~32 oz~Reggano~1.69 Pasta, Penne Rigate~16 oz~Reggano~0.99 Pasta, Rotini/Rotelle/Fusilli~16 oz~Priano, premium fusilli~1.49 Pasta, Spaghetti~32 oz~Reggano~1.59 Peanut Butter~18 oz~BerryHill, creamy and crunchy~2.29 Peanuts, roasted~16 oz~Southern Grove~2.69 Pears~2 lbs~ ~1.99 Pepper, black, ground~4 oz~Spice Club, pure ground~1.99 Pizza, frozen (premium)~32.7 oz~Mama Cozzi's, self-rising crust, pepperoni or supreme~3.89 Pizza, frozen (simple)~21.1 oz~Mama Cozzi's, pepperoni, sausage, combo, extra cheese or deluxe~1.99 Plastic Wrap~200 sq ft~Boulder~1.49 Pork Tenderloin, small~per lb~Roseland, packaged at about 1.5 lbs~3.99 Potatoes, Russet ~5 lbs~Freshire Farms, Del Monte~2.89 Potatoes, gold (Yukon)~5 lbs~Del Monte~2.99 Potatoes, red~5 lbs~Freshire Farms, Del Monte~2.49 Preserves, strawberry~18 oz~Berry Hill, strawberry~1.59 Pretzels~16 oz~Clancys, mini & sticks~1.29 Ribs, Baby Back (pork, unseasoned)~per lb~Roseland, packaged at about 3-5 lbs~3.49 Rice, instant, white~28 oz~Rice Bowl, enriched~2.49 Rice, regular~3 lbs~Rice Bowl, enriched, long grain white~1.69 Salad Dressing~16 fl oz~Fit & Active (reduced fat), various types, Tuscan Garden (regular), Ranch~1.39 Salami, sliced~8 oz~Deli Premium, hard or Genoa salami~2.79 Salsa, medium~24 oz~Casa Mamita~1.49 Salt, iodized~26 oz~Stonemill, iodized~0.35 Soda, bottle~2 L~Summit, Citrus Twist or GT Cola~0.69 Soda, can~12 pack~Summit, GT Cola, Mountain Frost and other flavors~2.29 Soup, Chicken Noodle, condensed~10.5 oz~Chef's Cupboard~0.59 Soup, Chicken Noodle, regular~18.6 oz~Fit & Active~1.39 Soup, Tomato, condensed~10.75 oz~Chef's Cupboard~0.49 Sour Cream~16 oz~Friendly Farms, regular or light~1.29 Spaghetti Sauce~24 oz~Reggano, traditional, meat or mushroom~1.19 Sugar, brown~32 oz~Baker's Corner~1.49 Sugar, powdered~32 oz~Baker's Corner~1.49 Sugar, white~4 lbs~Baker's Corner~2.19 Syrup, breakfast~24 fl oz~Aunt Maple's, regular or lite~1.59 Tea, green, bags~1.5 oz~Benner, 24 Bags~1.19 Tomato Paste~6 oz~Happy Harvest~0.39 Tomato Sauce~8 oz~Happy Harvest~0.29 Tomatoes, slicer~24 oz~Various growers, 3ct~1.59 Tuna, chunky, in water~5 oz~Northern Catch~0.59 Tuna, solid, in water~5 oz~Northern Catch~1.15 Vanilla Extract, pure (not imitation)~2 fl oz~Stonemill~1.99 Veggies 1, frozen (peas)~16 oz~Happy Harvest, peas~0.89 Veggies 2, frozen (other)~16 oz~Happy Harvest, corn~0.65 Waffles, frozen~12.3 oz~Breakfast Best, 10 waffles~1.29 Water, regular/drinking~12 L~PurAqua, 24 x 0.5 L (12 L)~2.49 White Bread/Toast, enriched~20 oz~L'oven Fresh~0.79 Wine, table, Cabernet~750 ml~Winking Owl~2.89 Wine, table, Chardonnay~750 ml~Winking Owl~2.89 Wine, table, White Zinfandel~750 ml~Winking Owl~2.89 Yoghurt, Dannon (etc.)~16 oz~Friendly Farms Probiotic, assorted flavors, 4 x 4 oz, low fat~1.79 Yogurt, Fage, w/ flavor~5.3 oz~Fage, various flavors ("Aldi special buy")~1.19 Yogurt, flavored, cup~6 oz~Friendly Farms, regular, Fit & Active, non fat, assorted flavors~0.39 Yogurt, greek style, plain~6 oz~Friendly Farms ("Aldi special buy")~0.89 Yogurt, plain~32 oz~Fit & Active, non fat~1.99 ; Run; data amazon; infile datalines dlm="~"; input product : $200. weight : $20. description : $500. price ; datalines; Aluminum Foil~75 sq ft~Boulder~3.23 Apple Juice~64 fl oz~Nature's Nectar~5.04 Apple Sauce~25 oz~Sweet Harvest, regular or cinnamon~0.65 Apples, Gala, bag~3 lbs~Washington apples, various growers~3.87 Apples, Red/Golden Delicious (and/or other), bag~3 lbs~Washington apples, various growers, Red Delicious, Golden Delicious, Fuji, Granny Smith~6.83 Bacon~16 oz~Appleton Farms~2.64 Bagles, plain~20 oz~L'oven Fresh, 6 ct~0.75 Barbeque Sauce~18 oz~Burman's, original, hickory or honey~1.35 Beef Stew Meat~per lb~Cattlemen's Ranch, packaged at about 1.5 lbs~4.98 Beer, bottle, pilsener, import~6 pack~Wernesgrüner, Germany, 6 x 12 oz~6.16 Brats, 4-6 pack~14 oz~Parkview, 6 brats, smoked, cheddar or stadium style~1.75 Bread Crumbs~15 oz~Chef's Cupboard~1.3 Bread, 12-grain/multi-grain~24 oz~L'oven Fresh~1.55 Breakfast Sausage, frozen~7 oz~Breakfast Best, 10 links~1.26 Butter, real, unsalted/salted~1 lb~Countyside Creamery~2.44 Carrots, whole~2 lbs~Freshire Farms~0.65 Cheery Pie Filling~21 oz~Baker's Corner~2.98 Cheese Singles (imitation)~10.67 oz~Lynder, 16 slices~0.5 Cheese, Brie 1~6 oz~President, brie log ("Aldi special buy")~5.29 Cheese, Parmesan, jar~8 oz~Reggano, 100% real grated~2.25 Cheese, block (regular)~8 oz~Happy Farms, assorted varieties~1 Cheese, shredded, Mexican style~12 oz~Happy Farms~3.98 Cheese, shredded, Mozarella~16 oz~Happy Farms~3.63 Cheese, sliced, regular~8 oz~Happy Farms, 10 slices~4.1 Chicken Breasts, frozen~3 lbs~Kirkwood~10.39 Chicken Nuggets, frozen~32 oz~Kirkwood~4.73 Chicken Tenderloins, frozen~2.5 lbs~Kirkwood~3.59 Chips, potato chips~11 oz~Clancy's, assorted~2.1 Chocolate Chip Cookie Dough~16 oz~Buehler's, makes 24 cookies~1 Cocoa Rice Cereal~11 oz~Millville~1.3 Coffee~17.6 oz~Grandessa, German Roasted, mild or regular~12.9 Cold Cuts, ham or chicken~1 lb~Lunch Mate, ham, chicken or turkey~3.57 Corn Flakes, regular~18 oz~Millville~1.3 Corn Flakes, sugar frosted~17 oz~Millville~0.9 Cottage Cheese~24 oz~Friendly Farms, regular or low fat~1.09 Cream Cheese~8 oz~Happy Farms (regular), Fit & Active (low fat, Neufchatel)~0.6 Croissants~10 oz~L'oven Fresh,~3.51 Eggs, regular~dozen~Goldhen, grade A large, white~0.74 Fish 1, frozen (flounder)~16 oz~Sea Queen, 4 fillets (wild caught)~2 Fish 2, frozen (tilapia)~24 oz~Tilapia, Sea Queen, 6 fillets~5.41 Fish 3, frozen~24 oz~Mahi Mahi, Sea Queen, 4 fillets (wild caught)~2 Flour, all purpose~5 lbs~Baker's Corner, enriched and bleached~3.33 Flour, self rising~5 lbs~Baker's Corner, enriched and bleached~0.8 French Fries, frozen~32 oz~Season's Choice~0.95 Fruit 1, frozen (strawberries)~16 oz~Season's Choice, strawberry or mixed fruit~1.49 Fruit 2, frozen~16 oz~Season's Choice, raspberries or "Triple Berry Blend"~1.93 Granola Bars, high fiber~7 oz~Millville, 6 bars, chocolate or peanut butter~1.06 Granola Bars, regular~8.4 oz~Millville, 10 bars, assorted flavors~1.26 Grapes, red~2 lbs~King Fresh, Produce Kountry and other growers, seedless~1.5 Green Beans, canned~14.5 oz~Happy Harvest, French style or cut~0.88 Ground Beef (chuck, 80/20)~per lb~All natural~3.63 Ground Beef (sirloin, 90/10)~per lb~All natural~2.02 Ground Beef, frozen~1 lb~No name, 85%, all natural~3.81 Ground Turkey~19.2 oz~Fit & Active, Prestage Farms~1.5 Ground Turkey, frozen~1 lb~Kirkwood~1.1 Ham, boneless~per lb~Appleton, sliced, packaged at 2 lbs, 1/4 ham~1.5 Honey~24 oz~Berry Hill, clover honey, all natural, 100% pure~3.92 Honey Crunch Oats~16 oz~Millville~3.61 Hot Dog Buns~12 oz~L'oven Fresh, 8 ct~1.19 Hot Dogs, beef~16 oz~Parkview, 8 ct~2.92 Ice Cream, premium~1.75 qt~Belmont, assorted flavors~4.3 Ice Cream, simple~0.5 gal~Sundae Shoppe, assorted flavors~2.43 Jalopeño Peppers, canned~12 fl oz~Tuscan Garden, rings, hotor mild~1.84 Ketchup~40 oz~Burman's~2.07 Kielbasa~16 oz~Parkview~1 Lemons~2 lbs~Various growers~3.7 Lettuce, iceberg~head~Capurro and other growers~1.23 Mandarin Oranges, canned~11 oz~Sweet Harvest~0.25 Margarine/Spread~16 oz~Countyside Creamery ("Tastes Like Butter")~1.75 Mayonnaise~30 fl oz~Burman's~1.94 Milk~1 gal~Friendly Farms, whole, 2% or non fat~2.02 Milk Chocolate Bar~5.29 oz~Choceur, Austrian~3.54 Mushrooms, Button, whole~8 oz~Freshire Farms~0.5 Mushrooms, stems/pieces~4 oz~Happy Harvest~0.3 Mustard, dijon~12 oz~Burman's~0.74 Mustard, yellow~14 oz~Burman's~0.35 Oat Meal~15.1 oz~Millville, 10 packets, maple & brown sugar, also as variety pack~2.22 Oil, Canola, 100% pure~48 fl oz~Carlini~3.51 Oil, Olive, 100% pure~16.9 fl oz~Carlini~1.73 Oil, Olive, extra virgin~16.9 fl oz~Carlini~1.75 Onions, yellow~3 lbs~Various growers~0.85 Orange Juice, not from concentrate~2 qt~Nature's Nectar~1.2 Oranges~4 lbs~Various growers, navel~2.36 Paper Towles~8 rolls~Boulder, 2-ply, 416 sheets total~3 Pasta, Egg Noodles~12 oz~Reggano~2.16 Pasta, Ellbow Maccaroni~32 oz~Reggano~1.54 Pasta, Penne Rigate~16 oz~Reggano~0.5 Pasta, Rotini/Rotelle/Fusilli~16 oz~Priano, premium fusilli~0.75 Pasta, Spaghetti~32 oz~Reggano~0.97 Peanut Butter~18 oz~BerryHill, creamy and crunchy~3.03 Peanuts, roasted~16 oz~Southern Grove~3.01 Pears~2 lbs~ ~2.46 Pepper, black, ground~4 oz~Spice Club, pure ground~2.42 Pizza, frozen (premium)~32.7 oz~Mama Cozzi's, self-rising crust, pepperoni or supreme~1.95 Pizza, frozen (simple)~21.1 oz~Mama Cozzi's, pepperoni, sausage, combo, extra cheese or deluxe~1.56 Plastic Wrap~200 sq ft~Boulder~1.65 Pork Tenderloin, small~per lb~Roseland, packaged at about 1.5 lbs~4.34 Potatoes, Russet~5 lbs~Freshire Farms, Del Monte~1.45 Potatoes, gold (Yukon)~5 lbs~Del Monte~6.27 Potatoes, red~5 lbs~Freshire Farms, Del Monte~2.74 Preserves, strawberry~18 oz~Berry Hill, strawberry~0.82 Pretzels~16 oz~Clancys, mini & sticks~1.25 Ribs, Baby Back (pork, unseasoned)~per lb~Roseland, packaged at about 3-5 lbs~2.9 Rice, instant, white~28 oz~Rice Bowl, enriched~1.25 Rice, regular~3 lbs~Rice Bowl, enriched, long grain white~1.31 Salad Dressing~16 fl oz~Fit & Active (reduced fat), various types, Tuscan Garden (regular), Ranch~1.94 Salami, sliced~8 oz~Deli Premium, hard or Genoa salami~1.4 Salsa, medium~24 oz~Casa Mamita~2.22 Salt, iodized~26 oz~Stonemill, iodized~0.32 Soda, bottle~2 L~Summit, Citrus Twist or GT Cola~0.44 Soda, can~12 pack~Summit, GT Cola, Mountain Frost and other flavors~3.21 Soup, Chicken Noodle, condensed~10.5 oz~Chef's Cupboard~0.71 Soup, Chicken Noodle, regular~18.6 oz~Fit & Active~2.41 Soup, Tomato, condensed~10.75 oz~Chef's Cupboard~0.47 Sour Cream~16 oz~Friendly Farms, regular or light~1.99 Spaghetti Sauce~24 oz~Reggano, traditional, meat or mushroom~1.94 Sugar, brown~32 oz~Baker's Corner~0.75 Sugar, powdered~32 oz~Baker's Corner~1.93 Sugar, white~4 lbs~Baker's Corner~1.46 Syrup, breakfast~24 fl oz~Aunt Maple's, regular or lite~0.8 Tea, green, bags~1.5 oz~Benner, 24 Bags~2.09 Tomato Paste~6 oz~Happy Harvest~0.2 Tomato Sauce~8 oz~Happy Harvest~0.15 Tomatoes, slicer~24 oz~Various growers, 3ct~2.27 Tuna, chunky, in water~5 oz~Northern Catch~0.3 Tuna, solid, in water~5 oz~Northern Catch~1.64 Vanilla Extract, pure (not imitation)~2 fl oz~Stonemill~3.33 Veggies 1, frozen (peas)~16 oz~Happy Harvest, peas~1.17 Veggies 2, frozen (other)~16 oz~Happy Harvest, corn~0.69 Waffles, frozen~12.3 oz~Breakfast Best, 10 waffles~3.48 Water, regular/drinking~12 L~PurAqua, 24 x 0.5 L (12 L)~1.25 White Bread/Toast, enriched~20 oz~L'oven Fresh~1.09 Wine, table, Cabernet~750 ml~Winking Owl~1.45 Wine, table, Chardonnay~750 ml~Winking Owl~1.99 Wine, table, White Zinfandel~750 ml~Winking Owl~5.19 Yoghurt, Dannon (etc.)~16 oz~Friendly Farms Probiotic, assorted flavors, 4 x 4 oz, low fat~1.26 Yogurt, Fage, w/ flavor~5.3 oz~Fage, various flavors ("Aldi special buy")~0.8 Yogurt, flavored, cup~6 oz~Friendly Farms, regular, Fit & Active, non fat, assorted flavors~0.2 Yogurt, greek style, plain~6 oz~Friendly Farms ("Aldi special buy")~3 Yogurt, plain~32 oz~Fit & Active, non fat~1.83 ; Run;

The WALMART and AMAZON tables each contain a list of 140 grocery items and their respective prices. They each have the following four columns:​

• PRODUCT
• WEIGHT
• DESCRIPTION
• PRICE

Next