same date last month

[anirudhs]

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

[PeterClemmensen]

Use the INTNX function like this

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

[andreas_lds]

---

@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.

[RW9]

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