topic first and last day of a month in SAS Procedures

first and last day of a month

Tal — Thu, 13 Aug 2015 19:16:53 GMT

hi guys,

how do i get the first and last days of let's say last month or June. What would be the code/query to do that?

Thanks,

Tal

PhilC — Thu, 13 Aug 2015 19:35:55 GMT

data _null_; 
  x=intnx("month",today(),0);
  y=intnx("month",today(),1)-1; 
  format x y mmddyy10.; 
  put x= y=;
run;

Tal — Thu, 13 Aug 2015 19:44:45 GMT

Thanks Phil

dcruik — Thu, 13 Aug 2015 19:46:10 GMT

Similar to PhilC's, although it's in a macro form: