Count

[ismahero2]

Hi,

I have a table like this one:

Header 1	Header 2	Header 3
999	454565	5654
996	gdrgr	egdg
996	df	dgfd
999	df	xd
555	dfd	ff
444	fef	fe
333

Now, I want to create a table with only the rows in column "Header 1" where there is a distinct record.  The resulting table should be something like this:

UniqueNumbers
555
444
333

I tried to do a Count but I am having problems selecting Where Count=1.   Any ideas?

[Haikuo]

The following code may get you started:

data have;

infile cards truncover;

input (Header_1 Header_2 Header_3) (:$);

cards;

999 454565 5654

996 gdrgr egdg

996 df dgfd

999 df xd

555 dfd ff

444 fef fe

333

;

proc sql;

  create table want as

    select header_1

  from have

  group by header_1

  having count(*) =1

  ;

quit;

Haikuo

[Peter_C]

A data step solution

PROC SORT DATA= have ;

BY header1;

RUN ;

DATA unique_header1 ;

SET have ;

BY header1 ;

IF FIRST.header1 and LAST.header1;

RUN;

[pradeepalankar]

proc sql;

select header1 as UniqueNumbers from have group by header1 having count(*)=1;

quit;