topic Re: Replace the character with lastest records in SAS Programming

Replace the character with lastest records

shiv999 — Wed, 04 Nov 2020 12:15:18 GMT

Hi guys
My data is like
Id. Name $ 10 Doj :date9. dot:date9.;
11235 Jim 12jul2017 01auj2018
11235 Jim. 12jul2019 01auj2019
11235 Jimcarod 12jan2020 01feb2020
11235 Jimcarod 12jul2020 01auj2020

My code should replace all the row with name Jimcarod . As its is the latest entry and have same id

Re: Replace the character with lastest records

PaigeMiller — Wed, 04 Nov 2020 12:24:50 GMT

Duplicate question. @shiv999 please don't post a question more than once. Everyone should respond at https://communities.sas.com/t5/SAS-Procedures/Replace-name-with-latest-entry/td-p/696461

rtRe: Replace the character with lastest records

Ksharp — Wed, 04 Nov 2020 13:06:37 GMT

Assuming dataset have beed sort by ID , Date.

data have;
input Id  Name $  Doj :date9. dot:date9.;
format doj dot date9.;
cards;
11235 Jim 12jul2017 01aug2018
11235 Jim. 12jul2019 01aug2019
11235 Jimcarod 12jan2020 01feb2020
11235 Jimcarod 12jul2020 01aug2020
;

data want;
 do until(last.id);
  set have;
  by id;
 end;
 _name=name;
do until(last.id);
  set have;
  by id;
  name=_name;output;
 end;
 drop _name;
run;