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???
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;
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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.