03-04-2014 03:13 PM
data test(keep=ln tpr_date);
If I had this output prior to running the above sas script it looks like this
After running the program I would get this
However I would miss the unique value or
because 2 is the last.ln in the series. I would want this output
In this case both the ln and tpr_date need to capture the last unique values. Any ideas here???
03-04-2014 04:45 PM
Does this do what you want?
Create table test as
Select Distinct Ln_no, tpr_date
But you really need to expand on what you mean by "Unique" if you exclude the first record.