Question: 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

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

The final table EMPS should look similar to this

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
Get step-by-step solutions from verified subject matter experts
