@Maycrow wrote: OK, not sure what you mean by pseudo code, but here is more background: Original tables------------------ SERIAL CF_WRKR CF_WRKR2 BEG_DATE END_DATE 3333 none . 03/01/2020 03/30/2020 4564 none BCF45G6 03/01/2020 03/30/2020 Output desired ----------- SERIAL CF_WRKR CF_WRKR2 BEG_DATE END_DATE 3333 VGD5T67 VGD5T67 02/01/2020 03/30/2020 4564 BCF45G6 BCF45G6 03/01/2020 03/30/2020 /*Note the date change for 3333 that now should start at Feb1 instead of March 1 to pull its latest ID that is no more there in March (person was discontinued after Feb)*/
So you just want to change beg_date to 2/1/2020 for 3333?
data want;
set have;
if serial='3333' then beg_date='01FEB2020'd;
run;
... View more
