White Papers

Checking for Duplicates

Overview This paper demonstrates a quick way to find duplicates in a dataset (with both simple and complex keys). It discusses what to do when they are found, and shows the difference between the PROC SORT options NODUP and NODUPKEY. The last example presented in this paper shows how to use the option NODUPKEY to keep only the record with the highest value of a variable when duplicates are found.

Download White Paper

By downloading you agree to our Terms and Conditions. These include information regarding use of your personal data.

Publisher
SAS Institute
File Format
PDF
Date Published
Jun 1, 2007
Format
White Papers
Topics
Programming Languages, Software Engineering

Similiar White Papers

Generalizing Google's PageRank to Rank National Football League Teams

Generalizing Google's PageRank to Rank National Football League Teams

The ranking of sports teams is of significant importance to those who are involved with or interested in the various pro

Publisher: SAS Institute  |  Tags: soccer

Number Systems Decoded - Binary, Decimal, and Hexadecimal

Number Systems Decoded - Binary, Decimal, and Hexadecimal

In many IT-related fields of study, it is extremely valuable to have a good understanding of the number systems that are

Publisher: Global Knowledge

A "SAS Programmer's" Guide to SAS Enterprise Guide

A "SAS Programmer's" Guide to SAS Enterprise Guide

This paper will demonstrate how SAS programmers can use SAS Enterprise Guide as their primary interface to the SAS syste

Publisher: SAS Institute

SAS/AF: Running SCL Outside the Frame

SAS/AF: Running SCL Outside the Frame

SCL is a powerful programming language that has been part of SAS for many years. People use SCL for many reasons; some p

Publisher: SAS Institute  |  Tags: data

Getting Started With ActiveX Automation Using VB6: Understanding ActiveX Automation and Steps for Adding BarTender to a Visual Basic 6 Project

Getting Started With ActiveX Automation Using VB6: Understanding ActiveX Automation and Steps for Adding BarTender to a Visual Basic 6 Project

When one's label and envelope printing needs is complex or label-printing performance is mission-critical for the compan

Publisher: Seagull Scientific  |  Tags: applications, data, printing, productivity, software, software applications

SAS Institute White Papers

A Clever Demonstration of the SAS SUBSTR Function

A Clever Demonstration of the SAS SUBSTR Function

The SAS SUBSTR function differs from the substring function in other programming languages as it can be used on either s

Publisher: SAS Institute

Understanding Your Customer: Segmentation Techniques for Gaining Customer Insight and Predicting Risk in the Telecom Industry

Understanding Your Customer: Segmentation Techniques for Gaining Customer Insight and Predicting Risk in the Telecom Industry

The explosion of customer data in the last twenty years has increased the need for data mining aimed at Customer Relatio

Publisher: SAS Institute  |  Tags: crm, customer service, data, data mining

An Animated Guide: Proc Transpose

An Animated Guide: Proc Transpose

If one can think about a SAS data set as being made up of columns and rows, one can say Proc Transpose "Flips" the colum

Publisher: SAS Institute  |  Tags: data

Cool New Features in SAS Enterprise Miner 5.3

Cool New Features in SAS Enterprise Miner 5.3

SAS released Enterprise Miner 5.3 in late 2007 with a veritable plethora of cool new features for data miners everywhere

Publisher: SAS Institute  |  Tags: data, software

An Introduction to SAS Character Functions

An Introduction to SAS Character Functions

SAS software is especially rich in its assortment of functions that deal with character data. This class of functions is

Publisher: SAS Institute  |  Tags: data, software