topic Re: how to get distinct observation from a dataset in SAS Programming

how to get distinct observation from a dataset without SQL

new510 — Tue, 18 Jul 2017 14:02:44 GMT

how to get a count of distinct values from a variable without using proc sql ?

example dataset:

ID Name

101 AAA

102 BBB

103 CCC

105 EEE

101 AAA

103 CCC

Re: how to get distinct observation from a dataset

KachiM — Tue, 18 Jul 2017 14:01:49 GMT

Which variable to be used to find the distinct observations - either ID or Name can be used in your example. The simplest way is to use Proc sort with nodupkey.

For unique Name:

proc sort data = have nodupkey;
by Name;
run;

For unique ID:

proc sort data = have nodupkey;
by id;
run;

There several ways to do with data step and hash.

Editor's note: @Tom suggests PROC FREQ with NLEVELS option. Here's a full example of how that could work.

data t;
infile datalines dsd delimiter=',';
input  id $ name $;
datalines;
101,AAA
102,BBB
103,CCC
105,EEE
101,AAA
103,CCC
104,CCC
;
run;

proc freq data=t nlevels noprint;

/* save values of unique ID */
tables id / 
   out=uniqueId (where=(count=1));

/* save values of unique Name */
tables name / 
   out=uniqueName (where=(count=1));

/* save values of unique combination */
tables id * name / 
   out=uniqueWhole (where=(count=1));
run;

Re: how to get distinct observation from a dataset

Tom — Sat, 21 Feb 2015 14:06:20 GMT

PROC FREQ NLEVELS

Re: how to get distinct observation from a dataset

new510 — Sat, 21 Feb 2015 15:28:56 GMT

thank you

Re: how to get distinct observation from a dataset

new510 — Sat, 21 Feb 2015 15:33:20 GMT

Thank you Tom.