topic Converting a numeric month value into MMDDYY8. format in SAS Enterprise Guide

Converting a numeric month value into MMDDYY8. format

Caisha — Mon, 12 Sep 2016 19:32:15 GMT

Hello,

I am looking to use an INTNX statement in order to capture the month end date of a value, however I do not have a 'date' field that would normally be entered in the INTNX statement. What I do have is a column listing the numeric value of a month (i.e. 5 if it's May), and a 2nd column listing the numeric value of the year (i.e. 2016).

Any recommendations as to the fastest way to use the '5' and '2016' values to end up with a 05/31/2016 format?

Thanks!

Cait

Re: Converting a numberic month value into MMDDYY8. format

Astounding — Mon, 12 Sep 2016 18:53:29 GMT

Assuming your month and year values are numeric, here's a phrase you could enter wherever INTNX is expecting to see a date:

mdy(month, 1, year)

Re: Converting a numberic month value into MMDDYY8. format

PGStats — Mon, 12 Sep 2016 19:21:44 GMT

So that would be:

lastDayOfMonth = intnx("MONTH", mdy(month, 1, year), 0, "END");
format lastDayOfMonth mmddyy10.;

Re: Converting a numberic month value into MMDDYY8. format

Caisha — Wed, 14 Sep 2016 21:58:56 GMT

Hello PGStats,

Thank you for your response, it works perfectly! Thanks for helping me learn (I never used the MDY function).

Greatly appreciated!

Caisha