filter needed if a same id has 2 or more observations

vraj1 — Fri, 23 Mar 2018 07:37:04 GMT

I have a dataset which has some of the id's multiple and i n that case i only want the first.

For example if i have like below table i only need id 101 for type as A and not B record same with 103.

any help

Re: filter needed if a same id has 2 or more observations

Criptic — Fri, 23 Mar 2018 07:56:12 GMT

Use the first functionality in the data step e.g.

data aaa;
 set your_table;
 by id;
 if first.id then output;
run;