topic Selecting specific number of entry for each ID in SAS Programming

Selecting specific number of entry for each ID

SAS_AMUH — Thu, 02 Apr 2020 05:49:25 GMT

I have a large data that includes multiple observations for each ID.

If I only wanted to select the first entry of each ID, then the below code works.

If I wanted to select the first 5 entries of each ID, then what coding could I use?

Thanks for your help in advance.

data want;

set have;

by id;

if first.id;

run;

Re: Selecting specific number of entry for each ID

andreas_lds — Thu, 02 Apr 2020 05:59:47 GMT

@SAS_AMUH wrote:

I have a large data that includes multiple observations for each ID.

If I only wanted to select the first entry of each ID, then the below code works.

If I wanted to select the first 5 entries of each ID, then what coding could I use?

Thanks for your help in advance.

data want;

set have;

by id;

if first.id;

run;

You have to count the obs per ID, code is untestet:

data want;
  set have;
  by id;
  length counter 8;
  retain counter;
  if first.id then counter = 0;
  counter = counter + 1;
  if counter <= 5;
run;

Re: Selecting specific number of entry for each ID

SAS_AMUH — Thu, 02 Apr 2020 06:08:33 GMT

Thank you!