030-31: The SORT Procedure: Beyond the Basics

1 Paper 030-31 The SORT Procedure: Beyond the Basics Britta KelseyBassett, MGI PHARMA, Bloomington, MN ABSTRACT The SORT procedure is a very useful procedure with many options that often get overlooked. There are many options that you can use in both a DATA step as well as the SORT procedure, consequently eliminating the need for a DATA step in many instances. In this paper, I will describe these options in greater detail and show examples of how to use them. All examples shown were done in the SAS system for PCs, version The intended audience for this paper is beginner level SAS programmers with the basic knowledge of the SORT procedure. INTRODUCTION One of the first things that most SAS programmers learn is how to sort data using PROC SORT, but did you know you can also do things like create a new data set, subset your data, rename, drop, keep, format, or label your variables all in that same procedure?

The SORT procedure is a very useful procedure with many options that often get overlooked. There are many options ... Here is how the output data set DEMO1 looks: PATIENT SEX AGE PS 1 F 45 0 2 F 39 0 3 M 57 1 3 M 57 1 SUGI 31 Coders’ Corne r. 2 4 M 63 2 4 M 63 0 5 F 72 3

Loading..

Tags:

  Procedures, Output

Information

Related search queries