I have the dates like 2018-01, 2014-02, 1996-08, 2012-06, I would like to find the last day of that month (like is 31, 30 , or 28). I believe it also need to include if any leap years are there. Thanks in advance
endMonth = intnx('month', dateVariable, 0, 'e');
Use INTNX and the alignment parameter, E, which will align a date to the end of the month.
@SASuserlot wrote:
I have the dates like 2018-01, 2014-02, 1996-08, 2012-06, I would like to find the last day of that month (like is 31, 30 , or 28). I believe it also need to include if any leap years are there. Thanks in advance
endMonth = intnx('month', dateVariable, 0, 'e');
Use INTNX and the alignment parameter, E, which will align a date to the end of the month.
@SASuserlot wrote:
I have the dates like 2018-01, 2014-02, 1996-08, 2012-06, I would like to find the last day of that month (like is 31, 30 , or 28). I believe it also need to include if any leap years are there. Thanks in advance
Are these character strings, or numeric dates formatted to appear as 2018-01?
The INTNX function makes it easy to determine the last day of the month, if you have numeric dates in a variable which I have creatively named VARIABLENAME. The 'e' tells INTNX to find the last day of the month contained in VARIABLENAME.
last_day_of_month=intnx('month',variablename,0,'e');
thanks it worked
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.