topic Re: Return a past date from two variables in SAS Procedures

Return a past date from two variables

Q1983 — Tue, 04 Feb 2014 19:00:08 GMT

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

PGStats — Tue, 04 Feb 2014 19:27:30 GMT

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

pradeepalankar — Tue, 04 Feb 2014 19:28:50 GMT

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;

Q1983 — Tue, 04 Feb 2014 19:47:00 GMT

Thanks

Q1983 — Tue, 04 Feb 2014 19:47:22 GMT

Thanks