first and last day of a month

[Tal]

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 · Accepted solution]

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

[Tal]

Thanks Phil

[dcruik]

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