*51*

You can use **proc sort **in SAS to order the observations in a dataset by one or more variables.

The following examples show how to use this procedure with the following dataset in SAS:

**/*create dataset*/
data original_data;
input team $ points rebounds;
datalines;
A 12 8
A 12 7
A 14 5
A 23 9
A 20 12
A 11 7
A 14 7
B 20 2
B 20 5
B 29 4
B 14 7
B 19 8
B 17 9
B 30 9
;
run;
/*view dataset*/
proc print data=original_data;
**

**Example 1: Sort Observations Ascending**

We can use **proc sort** to sort the observations in the dataset in ascending order (smallest to largest) based on the value in the **points** column:

**/*sort by points ascending*/
proc sort data=original_data out=data2;
by points;
run;
/*view sorted dataset*/
proc print data=data2;**

Notice that the observations are sorted in ascending order based on the value in the **points** column.

**Example 2: Sort Observations Descending**

We can use **proc sort** with the **descending** statement to sort the observations in the dataset in descending order (largest to smallest) based on the value in the **points** column:

**/*sort by points descending*/
proc sort data=original_data out=data3;
by descending points;
run;
/*view sorted dataset*/
proc print data=data3;**

Notice that the observations are sorted in ascending order based on the value in the **points** column.

**Example 3: Sort Observations by Multiple Columns**

We can use **proc sort** with multiple variables listed in the **byÂ **statement to sort the observations in the dataset by multiple variables.

The following code shows how to sort the observations in the dataset by the value in the **points** column ascending, then by the value in the **rebounds** column ascending:

**/*sort by points ascending, then by rebounds ascending*/
proc sort data=original_data out=data4;
by points rebounds;
run;
/*view sorted dataset*/
proc print data=data4;**

Notice that the observations are sorted by the value in the **points** column ascending, then by the value in the **rebounds** column ascending.

**Additional Resources**

The following tutorials explain how to perform other common tasks in SAS:

How to Use Proc Append in SAS

How to Use Proc Tabulate in SAS

How to Use Proc Rank in SAS