topic Re: Only keep the records that have the later date in SAS Programming

Only keep the records that have the later date

yichentian226 — Sat, 05 Dec 2020 00:11:24 GMT

Hi community!

I have a question regarding below example:

date userid factor

8/21/2020 736ksls text

11/20/2020 736ksls text

02/07/2019 blea282 text

10/28/2020 blea282 text

Can anyone provide a solution to only keep the records ( when userid and factor are the same) with a later date? Thanks a lot from a beginner!

In this example I only want to keep 2 records:

date userid factor

11/20/2020 736ksls text

10/28/2020 blea282 text

Re: Only keep the records that have the later date

yichentian226 — Sat, 05 Dec 2020 01:22:20 GMT

I am answering myself hahah

proc sql;

create table xx as

select * from sample;

group by userid

having date_new=max(date);

quit;

Please feel free to share any thoughts you have 🙂

Re: Only keep the records that have the later date

novinosrin — Sat, 05 Dec 2020 01:27:41 GMT



data have;
input date :mmddyy10.             userid  $      factor  $;
format date mmddyy10.;
cards;
8/21/2020     736ksls      text

11/20/2020   736ksls      text

02/07/2019   blea282     text

10/28/2020   blea282     text
;

data want;
 set have;
 by userid factor notsorted;
 if last.factor;
run;
/*or SQL*/
proc sql;
 create table want as
 select *
 from have
 group by userid,factor
 having max(date)=date;
quit;

Re: Only keep the records that have the later date

yeji6144 — Sat, 05 Dec 2020 01:34:26 GMT

You can try:

IF LAST.userid=1 THEN DO;
OUTPUT;

Re: Only keep the records that have the later date

ballardw — Sat, 05 Dec 2020 09:34:03 GMT

@yeji6144 wrote:

You can try:

IF LAST.userid=1 THEN DO;
OUTPUT;

Better End; that Do;

or just:

If last.userid;