Retaining unique values in same order

sss — Fri, 30 Oct 2015 04:20:06 GMT

Hi All,

I have small query, I want to generate unique records from temp dataset on variable var, but the out dataset should have values in same order a c d b e.

Output:

----------
a
c
d
b
e

data temp;
input var$;
datalines;
a
a
a
c
c
c
d
b
b
b
e
e
;
run;

Re: Retaining unique values in same order

PGStats — Fri, 30 Oct 2015 04:34:58 GMT

Use by var notsorted :


data tempNoDup;
set temp; by var notsorted;
if first.var then output;
run;

proc print; run;

topic Retaining unique values in same order in SAS Data Management

Retaining unique values in same order

Re: Retaining unique values in same order