Help using Base SAS procedures

Return a past date from two variables

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 132
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,659

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,659

Re: Return a past date from two variables

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

PG

PG
Frequent Contributor
Posts: 132

Re: Return a past date from two variables

Thanks

Frequent Contributor
Posts: 132

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.

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

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