## Selecting certain number of observations into a table

Solved
Regular Contributor
Posts: 169

# Selecting certain number of observations into a table

Hi

A question please, i have a table containing a large number of observations, the table ( a case-control study) looks like this

A23

43

A86T80
A8777
A78776
A485
D2322
D771
D163
D994
C655
C5556
C77
C097

what i want is to create another table that would only include the first three observations in each group in the first columns (Header 1), here is the output

A23

43

A86T80
A485
D2322
D771
D163
C655
C5556
C77

Any help is appreciated

er of

Accepted Solutions
Solution
‎07-05-2015 04:07 PM
Posts: 5,056

## Re: Selecting certain number of observations into a table

A BY clause and a sum statement will do the trick :

data want;

if first.Header1 then order = 0;

order + 1;

if order <= 3;

drop order;

run;

PG

PG

All Replies
Solution
‎07-05-2015 04:07 PM
Posts: 5,056

## Re: Selecting certain number of observations into a table

A BY clause and a sum statement will do the trick :

data want;

if first.Header1 then order = 0;

order + 1;

if order <= 3;

drop order;

run;

PG

PG
Regular Contributor
Posts: 169

## Re: Selecting certain number of observations into a table

Thank you PGSats

🔒 This topic is solved and locked.