topic Re: same date last month in SAS Programming

same date last month

anirudhs — Tue, 10 Apr 2018 06:55:03 GMT

Hi,

I am looking for the code for the same date last month i.e

eg. 10APR2018 last month= 10MAR2018

11APR2018 last month= 11MAR2018.

similarly for next day.

as i want to keep both the dates in single variable.

Thanks

Re: same date last month

PeterClemmensen — Tue, 10 Apr 2018 07:20:45 GMT

Use the INTNX function like this

data dates;
    date='10apr2018'd;
    datelastmonth=intnx('month', date, -1, 's');
    format date: date9.;
run;

Re: same date last month

andreas_lds — Tue, 10 Apr 2018 07:45:53 GMT

@anirudhs wrote:

Hi,

I am looking for the code for the same date last month i.e

eg. 10APR2018 last month= 10MAR2018

11APR2018 last month= 11MAR2018.

similarly for next day.

as i want to keep both the dates in single variable.

Thanks

Then you don't have a date-variable anymore and working with the variable will be troublesome.

Re: same date last month

RW9 — Tue, 10 Apr 2018 08:01:28 GMT

This is not possible, you can either have:

A numeric variable with a date

A text variable with both dates converted to text and concatenated