I’m studying for my Statistics class and need an explanation.

detail see the attached file : Only Part1 and Part2

Part I: Combining SAS Data Sets

1. Concatenating Data Sets with Variables of Different Lengths and Types

a. Open p110e03. Submit the PROC CONTENTS steps or explore the data sets interactively to complete the table below. Fill in attribute information for each variable in each data set.

	Code		Company		ContactType
	Type	Length	Type	Length	Type	Length
orion.charities
orion.us_suppliers
orion.consultants

b. Write a DATA step to concatenate orion.charities and orion.us_suppliers and create a temporary data set, contacts.

c. Submit a PROC CONTENTS step to examine work.contacts. From which input data set were the variable attributes assigned?

d. Write a DATA step to concatenate orion.us_suppliers and orion.charities and create a temporary data set, contacts2. Notice that these are the same data sets as in the previous program, but they are in reverse order.

e. Submit a PROC CONTENTS step to examine work.contacts2. From which input data set were the variable attributes assigned?

f. Write a DATA step to concatenate orion.us_suppliers and orion.consultants and create a temporary data set, contacts3.

Why did the DATA step fail?

1. Merging a Sorted Data Set and an Unsorted Data Set in a One-to-Many Merge

a. Sort orion.product_list by Product_Level to create a new data set, work.product_list.

b. Merge orion.product_level with the sorted data set. Create a new data set, work.listlevel, which includes only Product_ID, Product_Name, Product_Level, and Product_Level_Name.

c. Create the report below. Include only those observations with Product Level equal to 3.
The results should contain 13 observations.

Partial PROC PRINT Output

Product_ Product_Level_

Level Name Product_ID Product_Name

3 Product Category 210100000000 Children Outdoors

3 Product Category 210200000000 Children Sports

3 Product Category 220100000000 Clothes

3 Product Category 220200000000 Shoes

3 Product Category 230100000000 Outdoors

2. Merging Using the IN= and RENAME= Options

a. Write a PROC SORT step to sort orion.customer by Country to create a new data set, work.customer.

b. Write a DATA step to merge the resulting data set with orion.lookup_country by Country
to create a new data set, work.allcustomer.

In the orion.lookup_country data set, rename Start to Country and rename Label to Country_Name.

Include only four variables: Customer_ID, Country, Customer_Name, and Country_Name.

c. Create the report below. The results should contain 308 observations.

Partial PROC PRINT Output

Obs Customer_ID Country Customer_Name Country_Name

1 . AD Andorra

2 . AE United Arab Emirates

…

306 3959 ZA Rita Lotz South Africa

307 . ZM Zambia

308 . ZW Zimbabwe

d. Modify the DATA step to store only those observations that contain both customer information
and country information. A subsetting IF statement that references the IN= variables in the MERGE statement must be added.

e. Submit the program to create the report below. The results should contain 77 observations.

Partial PROC PRINT Output

Country_

Obs Customer_ID Country Customer_Name Name

1 29 AU Candy Kinsey Australia

2 41 AU Wendell Summersby Australia

3 53 AU Dericka Pockran Australia

4 111 AU Karolina Dokter Australia

5 171 AU Robert Bowerman Australia