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
initial_date = intnx("MONTH", expiration_dt, -term, "SAME");
PG
Thanks
Thanks
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;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.