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?
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
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;
proc sql;
select header1 as UniqueNumbers from have group by header1 having count(*)=1;
quit;
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: