topic Re: Selecting Records Based on Appearances in SAS Programming

Selecting Records Based on Appearances

BCNAV — Wed, 08 Jul 2020 18:41:14 GMT

This is a bit of a weird request....I have some data on aircraft flights that I need to break out depending on how many times they appear in a group. The group is identified as follows:

daily_grouping
104042452
104042452
104042452
104042452
104042452
104042452
104042453
104042454
104042455
104042455
104042456
104042456
104042456

There are other variables as well, but the daily_grouping is the one to key in on. Here is what I would like:

1. If a daily_grouping number appears only once, it should be removed.

2. If a daily_grouping number appears more than once, then the first instance should be removed and n-1 should remain.

This means that in the example above the result would be:

daily_grouping
104042452
104042452
104042452
104042452
104042452
104042455
104042456
104042456

Any help would be appreciated! Not sure if multiple steps are needed.

Re: Selecting Records Based on Appearances

ballardw — Wed, 08 Jul 2020 18:56:55 GMT

data have;
input daily_grouping :$10.;
datalines;
104042452
104042452
104042452
104042452
104042452
104042452
104042453
104042454
104042455
104042455
104042456
104042456
104042456
;

data want;
   set have;
   by daily_grouping;
   if not first.daily_grouping;
run;

Re: Selecting Records Based on Appearances

andreas_lds — Wed, 08 Jul 2020 18:59:34 GMT

Untested code:

data want;
set have;
by daily_grouping;
if not first.daily_grouping;
run;

Re: Selecting Records Based on Appearances

BCNAV — Wed, 08 Jul 2020 21:17:14 GMT

thanks all!

Re: Selecting Records Based on Appearances

Ksharp — Thu, 09 Jul 2020 11:53:35 GMT

data have;
input daily_grouping :$10.;
datalines;
104042452
104042452
104042452
104042452
104042452
104042452
104042453
104042454
104042455
104042455
104042456
104042456
104042456
;

proc sort data=have dupout=want nodupkey;
by daily_grouping ;
run;