topic Re: Previous date column in SAS Programming

Previous date column

Question — Thu, 28 Jul 2022 09:23:52 GMT

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

Re: Previous date column

PaigeMiller — Thu, 28 Jul 2022 10:26:14 GMT

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.

Re: Previous date column

Question — Thu, 28 Jul 2022 10:45:08 GMT

Thank you Paige! This works perfectly 🙂