Deduping Question

Q1983 — Tue, 04 Mar 2014 20:13:57 GMT

data test(keep=ln tpr_date);

set test1;

by ln_no;

if last.ln_no;

run;

If I had this output prior to running the above sas script it looks like this

ln tpr_date

1 09/15/2013

1 10/15/2013

2 06/15/2014

2 06/22/2013

After running the program I would get this

ln tpr_date

1 10/15/2013

2 06/22/2013

However I would miss the unique value or

2 06/15/2014

because 2 is the last.ln in the series. I would want this output

ln tpr_date

1 10/15/2013

2 06/15/2014

2 06/22/2013

In this case both the ln and tpr_date need to capture the last unique values. Any ideas here???

Re: Deduping Question

Reeza — Tue, 04 Mar 2014 20:15:59 GMT

Why are you excluding the first record then? It appears to be unique.

data test(keep=ln tpr_date);

set test1;

by ln_no tpr_date;

if last.tpr_date;

run;

ballardw — Tue, 04 Mar 2014 21:45:09 GMT

Does this do what you want?

Proc Sql;

Create table test as

Select Distinct Ln_no, tpr_date

from test1;

quit;

But you really need to expand on what you mean by "Unique" if you exclude the first record.