Transcription of 030-31: The SORT Procedure: Beyond the Basics
{{id}} {{{paragraph}}}
Example: bankruptcy
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?
NODUPRECS AND NODUPKEY OPTIONS The NODUPRECS (or NODUP) and NODUPKEY options work similarly in that they both can eliminate unwanted observations, but NODUP compares all the variables in your data set while NODUPKEY compares just the BY variables. More specifically, if you use the NODUP option, PROC SORT compares all variable values for …
Tags:
Information
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document: