Help using Base SAS procedures

Count

Reply
Contributor
Posts: 22

Count

Hi,

I have a table like this one:

Header 1Header 2Header 3
9994545655654
996gdrgregdg
996dfdgfd
999dfxd
555dfdff
444feffe
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?

Respected Advisor
Posts: 3,124

Re: Count

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

Valued Guide
Posts: 2,175

Re: Count

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;

Frequent Contributor
Posts: 106

Re: Count

proc sql;

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

quit;

Ask a Question
Discussion stats
  • 3 replies
  • 270 views
  • 0 likes
  • 4 in conversation