topic Re: Count in SAS Procedures

Count

ismahero2 — Thu, 09 Jan 2014 00:06:40 GMT

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?

Re: Count

Haikuo — Thu, 09 Jan 2014 01:18:29 GMT

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

Re: Count

Peter_C — Fri, 10 Jan 2014 21:32:43 GMT

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;

Re: Count

pradeepalankar — Fri, 10 Jan 2014 21:56:59 GMT

proc sql;

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

quit;