DATA Step, Macro, Functions and more

same date last month

Reply
Contributor
Posts: 69

same date last month

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

PROC Star
Posts: 1,283

Re: same date last month

Use the INTNX function like this

 

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

Re: same date last month


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

Super User
Super User
Posts: 9,599

Re: same date last month

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

Ask a Question
Discussion stats
  • 3 replies
  • 95 views
  • 2 likes
  • 4 in conversation