Loading Multiple Hash Objects from SAS Data Sets

Please complete the following in SAS or Provide codes of how to complete A, B, C and D at the bottom

The data set Orion.product_list contains Product_ID and Product_Name for products sold

The data set orion.customer_dim contains Customer_ID, Customer_Country and Customer_Name for customers who made purchases

The data set orion.country contains Country and Country_Name

The data set orion.order_fact contains Customer_ID and information about the orders

A. First write a code that would create a new data set named billing that reads Customer_ID, Order_date, Product_ID, Quantity and Total_Retail_Price from the table orion.order_fact

B. Then write a code that would create two HASH objects: 1. from orion.customer_dim with the key product_ID and the data Product_Name. 2. from Orion.country with the key Country and the data Country_Name

c. Next, write a code to create a third Hash object from orion.customer_dim with the key Customer_ID and the data Customer_Country and Customer_Name

D. Finally write a code that would use the three hash objects to lookup Customer_Name, Country_Name and Product_Name

The final result should consist of a code that uses the three hash objects created in part (b,c) and looks up the variables Customer_Name, Country_Name and product_Name

product_list Product ID Product Name Supplier ID Product Level Product Ref ID 4 3 210000000000 2 210100000000 3 210000000000 2 210200000000 1 210200100000 1 210200100000 2 210200000000 1 210200200000 1 210200200000 2 210200000000 1 210200300000 1 210200300000 1 210200300000 2 210200000000 1 210200400000 1 210200400000 2 210200000000 1 210200500000 1 210200500000 1 210200500000 1 210200500000 2 210200000000 1 210200600000 1 210000000000 Children 2 210100000000 Children Outdoors 3 210100100000 Outdoor things, Kids 4 210200000000 Children Sports 5 210200100000 A-Team, Kids 6 210200100009 Kids Sweat Round Neck,Large Logo 3298 3298 7 210200100017 Sweatshirt Children's O-Neck 8 210200200000 Bathing Suits, Kids 9 210200200022 Sunfit Slow Swimming Trunks 10 210200200023 Sunfit Stockton Swimming Trunks Jr. 11 210200300000 Eclipse, Kid's Clothes 12 210200300006 Fleece Cuff Pant Kid'S 13 210200300007 Hsc Dutch Player Shirt Junior 14 210200300052 Tony's Cut & Sew T-Shirt 15 210200400000 Eclipse, Kid's Shoes 16 210200400020 Kids Baby Edge Max Shoes 17 210200400070 Tony's Children's Deschutz (Bg) Shoes 18 210200500000 Lucky Guy, Kids 19 210200500002 Children's Mitten 20 210200500006 Rain Suit, Plain w/backpack Jacket 21 210200500007 Bozeman Rain & Storm Set 22 210200500016 Teen Profleece w/Zipper 23 210200600000 N.D. Gear, Kids 24 210200600056 Butch T-Shirt with V-Neck 6153 6153 1303 1303 1303 1303 1303 772 772 772 772 4742 product_list Product ID Product Name Supplier ID Product Level Product Ref ID 4 3 210000000000 2 210100000000 3 210000000000 2 210200000000 1 210200100000 1 210200100000 2 210200000000 1 210200200000 1 210200200000 2 210200000000 1 210200300000 1 210200300000 1 210200300000 2 210200000000 1 210200400000 1 210200400000 2 210200000000 1 210200500000 1 210200500000 1 210200500000 1 210200500000 2 210200000000 1 210200600000 1 210000000000 Children 2 210100000000 Children Outdoors 3 210100100000 Outdoor things, Kids 4 210200000000 Children Sports 5 210200100000 A-Team, Kids 6 210200100009 Kids Sweat Round Neck,Large Logo 3298 3298 7 210200100017 Sweatshirt Children's O-Neck 8 210200200000 Bathing Suits, Kids 9 210200200022 Sunfit Slow Swimming Trunks 10 210200200023 Sunfit Stockton Swimming Trunks Jr. 11 210200300000 Eclipse, Kid's Clothes 12 210200300006 Fleece Cuff Pant Kid'S 13 210200300007 Hsc Dutch Player Shirt Junior 14 210200300052 Tony's Cut & Sew T-Shirt 15 210200400000 Eclipse, Kid's Shoes 16 210200400020 Kids Baby Edge Max Shoes 17 210200400070 Tony's Children's Deschutz (Bg) Shoes 18 210200500000 Lucky Guy, Kids 19 210200500002 Children's Mitten 20 210200500006 Rain Suit, Plain w/backpack Jacket 21 210200500007 Bozeman Rain & Storm Set 22 210200500016 Teen Profleece w/Zipper 23 210200600000 N.D. Gear, Kids 24 210200600056 Butch T-Shirt with V-Neck 6153 6153 1303 1303 1303 1303 1303 772 772 772 772 4742