topic Counting rows in SAS Procedures

Counting rows

InfoGuru — Mon, 04 Aug 2008 12:26:22 GMT

This is a very stupid question for which i seem to have lost my code and forgotten the rest. if someone can help me great.
To uniquely count rows in a data set with duplicate primary keys e.g. Three rows with data with the same primary key and i want to count them 1,2,3.

Re: Counting rows

sbb — Mon, 04 Aug 2008 15:15:32 GMT

DATA step logic (sorted input file) using a BY statement and IF FIRST._varname_ logic to increment a user SAS variable for all non-FIRST conditions and assign a value of 1 for the FIRST condition.

* input to next DATA step is sorted on _primary_key_variables_. ;
DATA _output2_;
set _input1_;
BY _primary_key_variables_;
IF FIRST._your_last_break_variable_ THEN DUPCOUNT = 0;
IF NOT (FIRST._your_last_break_variable_ AND LAST._your_last_break_variable_) THEN DUPCOUNT + 1;
RUN;

Scott Barry
SBBWorks, Inc.

Re: Counting rows

mftuchman — Tue, 05 Aug 2008 18:13:30 GMT

Another method that may work if you just want the counts of each duplicate key tuple is to use PROC FREQ with the LIST option.