Solved: first and last day of a month - SAS Support Communities

🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.

Pyrite | Level 9

Pyrite | Level 9

first and last day of a month

Posted 08-13-2015 03:16 PM (3268 views)

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

1 ACCEPTED SOLUTION

Accepted Solutions

Rhodochrosite | Level 12

Rhodochrosite | Level 12

Re: first and last day of a month

Posted 08-13-2015 03:35 PM (3497 views) | In reply to Tal

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

View solution in original post

3 REPLIES 3

Rhodochrosite | Level 12

Rhodochrosite | Level 12

Re: first and last day of a month

Posted 08-13-2015 03:35 PM (3498 views) | In reply to Tal

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

Pyrite | Level 9

Pyrite | Level 9

Re: first and last day of a month

Posted 08-13-2015 03:44 PM (3212 views) | In reply to PhilC

Thanks Phil

Lapis Lazuli | Level 10

Lapis Lazuli | Level 10

Re: first and last day of a month

Posted 08-13-2015 03:46 PM (3212 views) | In reply to Tal

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

744853-sas-innovate-data-ai (1).jpg

Catch up on SAS Innovate 2026

Nearly 200 sessions are now available on demand in the Innovate Hub.