Sentry Page Protection

Please Wait...

Data Manipulation [2-18]

---

Creating Output Data Set
(Proc Sort)

You can also create an output data set for the sorted data.

Again, let's take a look at the DRINKS data set. 

Data Drinks; Infile Datalines dsd; Input Type $ Name:$50. Calories Fat; Datalines; Cold,Caramel Frappuccino® Light Blended Beverage,100,0 Cold,Coffee Frappuccino® Blended Beverage,180,2.5 Cold,Teavana® Shaken Iced Passion Tango™ Tea,0,0 Cold,Shaken Tazo® Iced Black Tea Lemonade,100,0 Cold,Nonfat Iced Vanilla Latte,120,0 Cold,Nonfat Iced Caramel Macchiato,140,1 Cold,Iced Coffee (with classic syrup),60,0 Cold,Iced Skinny Latte,70,0 Hot,Brewed Coffee,5,0 Hot,Brewed Tea,0,0 Hot,Nonfat Green Tea Latte,210,0 Hot,Nonfat Cappuccino,60,0 Hot,Nonfat Caffè Latte,100,0 Hot,Nonfat Caramel Macchiato,140,1 Hot,Soy Chai Tea Latte,180,2 Hot,Nonfat Caffè Mocha – hold the whip,170,2 Hot,Skinny Vanilla Latte,100,0 Hot,Steamed Apple Juice,170,0 Hot,Caffè Americano,10,0 ; Run;

 
OUT option

The OUT option allows you to specify the "output" data set.

Example

Proc Sort Data=Drinks Out=SortedDrinks;
By Calories;
Run;

The OUT option creates a new data set called SORTEDDRINKS. 

The SORTEDDRINKS data set contains the sorted data from the DRINKS data set. 

Data Set: SORTEDDRINKS

(try it!)
​
Note:

When using the OUT option, only the output data set is sorted.

The original (input) data set remains unchanged.

The DRINKS data set remains unsorted. ​

Data Set: DRINKS

WHERE Statement

You can also subset the output data set by using the WHERE statement. 

Example

Proc Sort Data=Drinks Out=HotDrinks;
By Calories;
Where Type = "Hot";
Run;

The OUT option creates a new output data set called HOTDRINKS:

The HOTDRINKS data set is created:

The WHERE statement tells SAS to keep only the hot drinks in the data set (Type = "Hot").

The HOTDRINKS data set contains only the "Hot" drinks. ​

​The "Cold" drinks are all removed.

​(try it!)

---

Exercise

Locate the CARS data set from the SASHelp library.

Sort the CARS data set by MSRP in descending order. Keep only BMW, Audi, Lexus, Mercedes-Benz and Porsche in the output data set and save the data set in the WORK library. 

Which car maker sells the most expensive car among the five?

Next

---

Need some help? 

Get Hint

HINT:
Make sure the order is sorted in descending order.

Get Solution

SOLUTION:
Proc Sort Data=SASHelp.Cars Out=Cars;
By descending MSRP;
Where Make in ("BMW" "Audi" "Lexus" "Mercedes-Benz" "Porsche");
Run;

Porsche.

---

Fill out my online form.

---