topic Re: Retain Certain Type Among Obs with the same ID in SAS Programming

Retain Certain Type Among Obs with the same ID

jcis7 — Fri, 02 Aug 2013 15:49:16 GMT

Hello! Any help you can give is appreciated!

I've a document with:

ID Type Duplicate (other fields, etc...)

12345678 B 1

12345676 A 1

12345677 A 3

12345667 B 3

12345654 A 4

12345432 B 4

How do you select for Type A of each duplicate and include all fields

Final Table

ID Type Duplicate (other fields, etc...)

12345676 A 1

12345677 A 3

12345654 A 4

Thanks very much!

Tom — Fri, 02 Aug 2013 15:52:50 GMT

I must not understand the question.

Why not just

where type = 'A';

????

jcis7 — Fri, 02 Aug 2013 16:34:23 GMT

I oversimplified the example. Your response was helpful for me to look at it from a different angle. Thanks!