Help using Base SAS procedures

Return a past date from two variables

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 141
Accepted Solution

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
Respected Advisor
Posts: 4,925

Re: Return a past date from two variables

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

PG

PG

View solution in original post


All Replies
Solution
‎02-04-2014 02:27 PM
Respected Advisor
Posts: 4,925

Re: Return a past date from two variables

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

PG

PG
Frequent Contributor
Posts: 141

Re: Return a past date from two variables

Thanks

Frequent Contributor
Posts: 141

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.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 190 views
  • 0 likes
  • 3 in conversation