Deduping Question

[Q1983]

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

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???

[Reeza]

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]

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.