Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Using the Add method with a Composite Key Please complete the following in SAS/provide codes of how to complete in SAS A. First, write a

Using the Add method with a Composite Key

Please complete the following in SAS/provide codes of how to complete in SAS

image text in transcribed

A. First, write a data step to create a NEW dataset named EMPS and use the ADD method to add the composite key values for State and Country, as well as the data values of State_Name and Country_Name from the table.

B. Then, write another code that would read in to EMPS from a data set orion.employee_Addresses and use the FIND method to perform a table lookup

image text in transcribed

The final table EMPS should look similar to this

image text in transcribed

The following table shows the state code, state name, country code, and country names of the states and countries for the Orion Star employees: Country Name State State Name Country FL PA CA US Pennsylvania US US AU California United States Australia The following table shows the state code, state name, country code, and country names of the states and countries for the Orion Star employees: Country Name State State Name Country FL PA CA US Pennsylvania US US AU California United States Australia

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions