Previous date column

[Question]

Hi,

I have the extraction_end_dates below

Have
extract_end_date
02-Apr-21
09-Apr-21
16-Apr-21
23-Apr-21
30-Apr-21

And I would like to get corresponding previous dates (+1 day) in another column like below

want 
extract_start_date extract_end_date
.                              02-Apr-21
03-Apr-21               09-Apr-21
10-Apr-21              16-Apr-21
17-Apr-21              23-Apr-21
24-Apr-21              30-Apr-21

Thank you, your help would be much appreciated

[PaigeMiller · Accepted solution]

data want;
    set have;
    extract_start_date=lag(extract_end_date)+1;
    format extract_start_date date11.;
run;

This assumes that your values of EXTRACT_END_DATE are actual numeric SAS date values.

[Question]

Thank you Paige! This works perfectly 🙂