Description

Use the Cars data set in the SP4R library to complete this exercise.

1. Creating a List of Unique Values
a. Use PROC SQL to create three new data tables. Let values of make be the unique levels of the make variable. Let the values of type be the unique levels of the type variable. Let the values of origin be the unique levels of the origin variable.
b. Create a new data table called mylist, which combines the three data tables.
Hint: This task requires you to column-bind data tables of different dimensions.
c. Print mylist to ensure that the data table is created correctly.
Obs Make Type Origin
1 Acura Hybrid Asia
2 Audi SUV Europe
3 BMW Sedan USA
4 Buick Sports
5 Cadillac Truck
6 Chevrolet Wagon
7 Chrysler
8 Dodge
9 Ford
10 GMC
11 Honda
12 Hummer
13 Hyundai
14 Infiniti
15 Isuzu
16 Jaguar
17 Jeep
18 Kia
19 Land Rover
20 Lexus
21 Lincoln
22 MINI
23 Mazda
24 Mercedes-Benz
25 Mercury
26 Mitsubishi
27 Nissan
28 Oldsmobile
29 Pontiac
30 Porsche
31 Saab
32 Saturn
33 Scion
34 Subaru
35 Suzuki

Chapter 3: Creating New Variables, Functions, and Data Tables Page 2 of 2

36 Toyota
37 Volkswagen