Help using Base SAS procedures

Deduping Question

Reply
Frequent Contributor
Posts: 132

Deduping Question

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

Super User
Posts: 17,960

Re: Deduping Question

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;

Super User
Posts: 10,550

Re: Deduping Question

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.

Ask a Question
Discussion stats
  • 2 replies
  • 162 views
  • 0 likes
  • 3 in conversation