## Return a past date from two variables

Solved
Regular Contributor
Posts: 179

# Return a past date from two variables

In a database table, lets call it test11 I have the following:

expiration_dt

term

Sample record

expiration_dt          term (expressed in months)

12/31/2019             12

12/31/2020              6

I need to take the expiration_dt divide it by the term and get the date in the past as a result

As an example 12/31/2019 becomes 12/31/2018

Accepted Solutions
Solution
‎02-04-2014 02:27 PM
Posts: 5,543

## Re: Return a past date from two variables

initial_date = intnx("MONTH", expiration_dt, -term, "SAME");

PG

PG

All Replies
Solution
‎02-04-2014 02:27 PM
Posts: 5,543

## Re: Return a past date from two variables

initial_date = intnx("MONTH", expiration_dt, -term, "SAME");

PG

PG
Regular Contributor
Posts: 179

## Re: Return a past date from two variables

Thanks

Regular Contributor
Posts: 179

## Re: Return a past date from two variables

Thanks

Frequent Contributor
Posts: 106

## Re: Return a past date from two variables

data test;

input expiration_dt mmddyy10. term;

format expiration_dt pastdate mmddyy10.;

pastdate=intnx('month',expiration_dt,-(term),'s');

cards;

12/31/2019 12

12/31/2020 6

;run;

🔒 This topic is solved and locked.