Now, you need to create
a temporary data set for the teams in the Eastern Conference.
-
On the
SAS tab,
click
Tasks, and then select
DataSort Data. The
Choose Data dialog
box appears.
-
Select the _SOCCERCLUB
data set as your input data source. In this example, the location
of this set is
SASApp:SASApp — SASDATA_SOCCERCLUB
.
-
Click
Filter & Sort. The
Modify
Data Source window appears.
-
-
-
In the first drop-down
menu, select
Conference.
-
In the second drop-down
menu, select
Equal to.
-
In the text box, enter
EC
.
You can also click
to select this value.
Click
OK to
apply this filter.
-
In the
Choose
Data dialog box, click
Details.
These details show that the filter is applied to your input data source.
Click
OK.
The Sort Data task appears.
-
In the
Data panel,
assign the W variable to the
Sort by role.
From the
W sort order drop-down menu, select
Descending.
In the selection pane,
click
Results.
-
In the
Results panel,
change the directory path in the
Location to save output
data field to
default-server:WORK.SOCCERCLUB
.
This path is where the temporary data set is saved. You will need
this information to run the List Data task later.
For this example, the
default location is
SASApp:WORK.SOCCERCLUB
.
-
Note: If you are prompted to replace
an existing data set, click
Yes in the dialog
box. Click
Run again in the Sort Data task.
The Sort Data task overwrites
the SoccerClub data set in the Work library. Now, this data set contains
only the teams in the Eastern Conference.