Selecting a specific observation of a variable

[hjjijkkl]

I have a big data, and i wanted to select a few obs of a variable. How can I do that with big data?

For example: I have a data similar to the table below

class	ID
D4	1
A6	2
F9	3
F9	4
C5	5
A6	6
R10	7
R10	8
R10	9

I want the output to look like this

class	ID
A6	2
F9	3
F9	4
A6	6
R10	7
R10	8
R10	9

[PeterClemmensen]

What is the logic here?

[hjjijkkl]

I have a big data and i am trying to create a table with selected obs of a variable. for example in the table I provided, in the variable class, I was trying to get only the obs identified as A6, F9 and R10 only.

[ballardw]

---

@hjjijkkl wrote:
I have a big data and i am trying to create a table with selected obs of a variable. for example in the table I provided, in the variable class, I was trying to get only the obs identified as A6, F9 and R10 only.

---

data want;

   set have;

   where class in ('A6' 'F9' 'R10');

run;

should do it.

[mtgkooks · Accepted solution]

If you're only looking to extract the classes that appear multiple times, you could use something like this:

proc sql;
create table output as
select
	a.class, a.id
from
	work.test a
inner join
	(
		select distinct
			b.class, 
            count(b.class) as class_count
      	from
			work.test b
      	group by
			b.class
      	having
			calculated class_count > 1
	) c
on
	a.class = c.class
order by
	a.class, a.id
;