How to find the every second observations in a dataset

ForrestYao — Tue, 19 Mar 2019 19:24:18 GMT

Hi there,

I remind an interview question a long time ago. the dataset looks like this:

ID Value

1 80

2 70

3 50

4 40

5 80

6 79

8 46

9 67...

The question is that: create a table that contains every second record in this dataset.

So the desired output would be sth like:

2 70

4 40

6 79

9 67...

Can anyone provide some tips ?

Thanks a lot!

Re: How to find the every second observations in a dataset

PaigeMiller — Tue, 19 Mar 2019 19:39:15 GMT

data want;
    set have;
    if mod(_n_,2)=0;
run;